What is the snytex to use LIKE with SQL? I know I have to somehow add % to the end of this but nothing I try works.

WHERE CUSTOMER_MASTER.CUSTOMER.CUSTOMER_ID LIKE '&CUSTOMER_ID';

This message has been edited. Last edited by: Kerry,

Try
WHERE CUSTOMER_MASTER.CUSTOMER.CUSTOMER_ID CONTAINS '&CUSTOMER_ID';

GOOGLE: SQL Like

Then, Add to Favorites...

A first point on call is the on-line documentation in Dev Studio.

Open the online help, select the index tab and enter like in the search box.

WebFocus LIKE processing is slightly different to SQL processing.

Hi

Which database are you using ?

Try this:

  
WHERE CUSTOMER_MASTER.CUSTOMER.CUSTOMER_ID LIKE '&CUSTOMER_ID.EVAL%';

Thanks everyone for your valuable input.

Sue, suggestion from our technical:

Assuming that no error messages are generated and that this is just producing no records, it may be that trailing blanks are the issue which could be coming from the source of the amper variable (usually an html form).

If this is the case, the trailing blanks will need to be removed so that the percent wild card will lay directly next to the last non blank character (unless you really want to look for them).

Here is an example which will print all LASTNAMES that begin with an A. Please note there are several ways to accomplish this. The example shows 2: one using UPCASE and the other using TRIM. This was extracted/modified from the following solution: http://techsupport.information...om/sps/21812077.html

-SET &CUSTNAM='A ';

-SET &CUSTNAMLEN=ARGLEN(&CUSTNAM.LENGTH,&CUSTNAM,'I2');
-SET &CNAM1FMT = 'A' || &CUSTNAMLEN;
-SET &WHCUST = UPCASE(&CUSTNAMLEN,&CUSTNAM,'&CNAM1FMT');
-SET &WHCUST2=TRIM('B',&CUSTNAM,&CUSTNAMLEN,' ',1,'&CNAM1FMT');

TABLE FILE EMPDATA
PRINT PIN LASTNAME FIRSTNAME
WHERE LASTNAME LIKE '&WHCUST..%'
END



Cheers,

Kerry