For a list of all the Characters you can use run this code
(CHAR(10)) = ENTER
(CHAR(13)) = SPACE
SET VAR vCount INTEGER = NULL
SET VAR vCharValueTxt TEXT = NULL
SET VAR vCharValue TEXT = NULL
SET ERROR MESSAGE 2038 OFF
DROP TAB tChar
SET ERROR MESSAGE 2038 ON
CREATE TEMPORARY TABLE `tChar` +
(`CharSyntax` TEXT(20) , +
`CharValue` TEXT (1) )
WHILE vCount <> 256 THEN
SET var vCount = (.vCount + 1)
SET VAR vCharValueTxt = ( (CHAR(40)) + 'CHAR' + (CHAR(40)) +
(CTXT(.vCount)) + (CHAR(41)) + (CHAR(41)) )
SET VAR vCharValue = &vCharValueTxt
INSERT INTO tChar +
(CharSyntax,CharValue) +
VALUES +
(.vCharValueTxt,.vCharValue)
ENDWHILE
CLEAR VAR vCount,vCharValueTxt,vCountValue
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
