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.
