In message
<[EMAIL PROTECTED]>,
"Israel, John R." <[EMAIL PROTECTED]> writes
You need the double quotes on the outside of the ...
SELECT FILE WITH FIELD LIKE "...LLOYD'S..."
Alternatively, you can often get away with no quotes. Loosely
speaking, you only NEED quotes on the outside if you have spaces in
your search string, though if you have a single quote in your search
string, that would likely confuse it.
The problem is, this is a program constructing a select string. I have
no control over what the user types in, and I want to do a literal
match. What if they enter something like "6A'S"?
Basically, I need to quote the search string to get a literal match,
which means I need to put quotes outside the dots, which means I need to
use all three different quote characters, which then doesn't work :-(
Cheers,
Wol
--
Anthony W. Youngman <[EMAIL PROTECTED]>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source Pick
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
