A
A
Ancure2018-01-23 10:53:29
Transact SQL
Ancure, 2018-01-23 10:53:29

Why doesn't the CONTAINSTABLE function return all values?

Tell me please!
I have two rows in the conditional table with the following content:
1. ZnDP SS1.04.CR53 Periodic
2. ZnDP SS1.04.01I Unloading
I want to get a table with these 2 values: I execute the
query
select
etable.[Name]
, RankData.*
, *
from
table as etable
, CONTAINSTABLE(table, Name, '("cc1.04*")') as RankData
where
etable.XRecID = RankData.[Key]
And it only returns the 1st row, with the CC1.04 POA field possessed. CR53 Periodic. It is not clear to me why the second line also did not get into this table, it also contains CC1.04
Why is that, please explain

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
d-stream, 2018-01-23
@d-stream

CONTAINSTABLE is based on fulltext, and there the dot has a special value (one of them is word delimiter)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question