Not sure, but is it treating "x""y" as 'x"y'? I know in some parsers, if you want to embed a double quote inside of double quotes you just put two side by side. Most PICK systems don't do that, but within a paragraph the rules may be different. Try putting spaces between the values.
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: July-11-12 4:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] Select Statement Invalid Unidata 7.1.20, pick flavor I have this quick paragraph to select records based on partial keys: 001: PA 002: SELECT WIPMTLRQ WITH @ID = "299486]""302667]""318583]""337991]""374396]""376742]""382767]""385661]" "398932]""415256]""445409]""453821]" "454353]""478175]""478845]""502457]" Bottom. However, this is what I get when I run it: No data retrieved from current (S)SELECT statement. Yet if I run SELECT WIPMTLRQ WITH @ID = "299486]" I get records returned. What am I missing? Thanks. Albert DeWitt, CPIM _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users