CODEWITHSUNDEEP
sql-serverfull-text-searchcontains
dkum
dkum

Reputation: 125

Fulltext Contains does not return rows

I have a row in a table that contains "DS012345" in a column called description When I use this query:

Select * from Tablename where Contains(Description, ' "*012345*" ')

This query returns no result. I have created the unique index, fulltext catalog, I have turned off the Stop Words using the Object Explorer. Still do not know why it does not return that row. Any suggestion or cause for this?

Thanksl.

Upvotes: 0

Views: 55

Answers (2)

romeu
romeu

Reputation: 1

Stop words is the number that it starts to seek for a word in your database.. Fulltext should be used to get the exact word, if you just want a part of the word you should use LIKE %...%.

Upvotes: 0

arahman
arahman

Reputation: 585

Why not just use LIKE instead to do a search.

Select * from Tablename where Description LIKE '%012345%'

Just does a search where 012345 appears anywhere within the description column.

Upvotes: 1

Related Questions