RE: [U2] SELECT problem with quote characters
Consider trying... SELECT FILE WITH FIELD LIKE LLOYD'S... --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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/
Re: [U2] SELECT problem with quote characters
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: u2-users@listserver.u2ug.org 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 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/
RE: [U2] SELECT problem with quote characters
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/
Re: [U2] SELECT problem with quote characters
Hi, This is why there are three types of string quote. You need SELECT FILE WITH FIELD LIKE \...LLOYD'S...\ Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/