You can use single quotes in the SELECT statement. Example: SELECT FILE.NAME WITH @ID EQ '"1234"'
will select the record with an id equal 1234 in quotes. (I tried it and it worked) Dana Baron System Manager Smugglers' Notch Resort -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, February 27, 2006 12:32 PM To: [email protected] Subject: [U2] [UD] "Escaping" a Quote Unidata 6.1: Is there a way to "escape a character" in a SELECT literal? Though I can't see it in the documentation, I know you can quote with the " or \ characters, but what if the literal contains both " and \ characters? What then? Or what if the value contains a "^" or "[" or "?" that aren't to be interpreted by the query engine? ??? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ------- 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/
