LIKE "...LLOYD'S..."
Nancy Fisher
Peninsula Truck Lines, Inc
Auburn, Washington
Visit our Website www.peninsulatruck.com
[EMAIL PROTECTED]
----- Original Message -----
From: "Anthony Youngman" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, August 06, 2008 8:18 AM
Subject: [U2] SELECT problem with quote characters
I'm trying to select a string that contains a single-quote, using the LIKE
operator. It works fine with EQ.
So if I do a " SELECT FILE WITH FIELD EQ "LLOYD'S" ", the select returns
exactly what I expect.
But if I do a " SELECT FILE WITH FIELD LIKE ..."LLOYD'S"... " it returns
pretty much the entire file
And if I do a " SELECT FILE WITH FIELD LIKE \..."LLOYD'S"...\ " it returns
nothing.
What on earth is the syntax for picking up an embedded quote in data in a
LIKE
comparison? PIOPEN flavour, by the way.
Cheers,
Wol
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
