LIKE question w/wildcards

[Mr. Bigglesworth]

I'm not sure if you'd have a definitive answer for this with what I can give you, but even a suggestion would help.

In one of our tables, when you run this query:

tsql "select count(DOCID) indexcnt from tbldoc where (tbldoc.myfield LIKE '(henrick,henrik)')"

you get a count of 1200 hits. However, when you run this variation, with wildcards:

tsql "select count(DOCID) indexcnt from tbldoc where (tbldoc.myfield LIKE '(henrick*,henrik*)')"

you get a count of zero.

Would you happen to know why the wildcard search might return zero hits? Thanks for the help, and if you need more information, please ask.

[John]

The () syntax is actually for defining inline thesaurus terms, and the * is not special, so it will look for "henrick*" literally with the '*' on the end.

[mark]

Perhaps you wanted
sql "select count(DOCID) indexcnt from tbldoc where tbldoc.myfield LIKE 'henrick* henrik* @0'"