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. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, August 06, 2008 11:18 AM To: [email protected] 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/
