Search Question

gazim · Post by **gazim** » Wed Aug 20, 2003 1:06 pm

Does texis sql care about single quotes in a phrase?

My query looks like this,
AUTHOR like "jay o'connor"
It did not find the record even though it exists in the table.
However, when I searched AUTHOR like "Jeff Connor" , it found the record that had the phrase "jeff connor" in it.

TIA.

gazim · Post by **gazim** » Wed Aug 20, 2003 1:13 pm

The following thread has the answer I am looking for.
Apologies for wasting your diskspace. thanks.

http://thunderstone.master.com/texis/ma ... 3ab6773610