Thunderstone Support Forums

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.

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