CODEWITHSUNDEEP
.netasp.netfull-text-search
Anoop Nadakkara
Anoop Nadakkara

Reputation: 3

Sql server full text indexing wild card search

I am having a trouble using full text indexing in sql server

Is it possible to search columns which starts with a specific word using full text indexing ??

Upvotes: 0

Views: 290

Answers (1)

Sean Bright
Sean Bright

Reputation: 120644

You can't anchor your searches like this with full text searches. The best you could do would be to use a LIKE (which is awful advice) if you want to find specific values at the front of a column like this.

Upvotes: 1

Related Questions