Search Question
Posted: 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.
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.