Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I attempt to search in the full-text catalog which is my created earlier, I haven't been finding any word within database.

For example:

My word: Where
CONTAINSTABLE(TABLO,*,' "*Where*" ')  

Here is no problem.


CONTAINSTABLE(TABLO,*,' "*here*" ') 

if I wrote a thing like above the line,no rows returning.What should I do?

share|improve this question
Any suggestions? – Cell-o Sep 18 '11 at 11:34
up vote 1 down vote accepted

I don't believe that full text search will match based on the back end of the word being passed in. You could have it match "Wher*" but not "*here". This is called prefix matching.

< prefix term> ::= {"word*" | "phrase*" }

Trying to match based on "*here" would be a VERY expensive match for the full text engine to do.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.