Allen: I use UD in PICK mode and the query processor has the same problem as the OP noted. UD doesn't like single quotes in PICK mode. In fact, numerous things don't work in AQL when in PICK mode.
I wasn't able to get any of the suggestions to work in UD. Bill >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Allen Egerton >Sent: Tuesday, August 12, 2008 6:56 PM >To: [email protected] >Subject: Re: [U2] TCL literal select > >Bruce Ordway wrote: >> Hi, >> >> I work with a Unidata/Dataflo system on HPUX. >> I am having trouble selecting records in my PARTS file. >> >> I want to select all parts that have a " in the description field (F1). >> People have been using " instead of INCH. >> This causes problems for me during processing some reports and exports. >> > >To include double-quote within field to be searched, use single quote as >delimiter. > >SELECT PARTS WITH F1 = '["' >-or- >SELECT PARTS WITH F1 LIKE '..."...' > > >-- >Allen Egerton >aegerton at pobox dot com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
