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
