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/
