Try the select like this SELECT FILE WITH FIELD LIKE "...LLOYD'S..."
Dan Goble Systems Administrator RATEX Business Solutions, Inc. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, August 06, 2008 11:18 AM To: u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/