Chris: Victor solution is correct; also, instead of the CHAR(39) you can use: SET VAR vSSN TEXT = ( '''' + '%' + .vLookupValue + '''' ) '''' represents 4 ' ( or whatever quote character you use) in a row. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Victor Timmons Sent: Tuesday, December 21, 2004 5:12 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: correcting data where there is a primary &foreign keys try this instead SET VAR vSSN TEXT = ( (CHAR(39)) + '%' + .vLookupValue + (CHAR(39)) ) This will give you ' ' around your text var your var will read '%whatever' and use &vSSN instead of .vSSN tested using 6.5++ (im at work) On 21 Dec 2004 at 14:07, Chris Szeto wrote: > Does anybody know why this does not work? > SET VAR vSSN TEXT = ('%' + .vLookupValue) > > CHOOSE vCID FROM #VALUES FOR DISTINCT + > CID,SSN,(LJS(FullName,35)) + > FROM PEOPLELIST + > WHERE SSN like .vSSN + > ORDER BY Debtor > > Yet this does work? > SET VAR vSSN TEXT = (.vLookupValue + '%') > > CHOOSE vCID FROM #VALUES FOR DISTINCT + > CID,SSN,(LJS(FullName,35)) + > FROM PEOPLELIST + > WHERE SSN like .vSSN + > ORDER BY Debtor > > The only difference is that the wildcard is in the front instead of the > back. When I tried both SQL in a select statement there would be > results. > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
