[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

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

Re: [U2] SELECT problem with quote characters

] 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

RE: [U2] SELECT problem with quote characters

@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

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