Chris,
I don't think that has ever worked - R:Base doesn't know when the wildcard
ends so that it can look for the value of vLookupValue.
You might be able to use a number of single character wildcards, however, if
your text has a constant length.
Regards,
Alastair.
----- Original Message -----
From: "Chris Szeto" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, December 21, 2004 7:07 PM
Subject: [RBG7-L] - Re: correcting data where there is a primary &foreign
keys
> 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.
>
