To search a field for an occurrence of a string supplied through a prompt variable create a condition that uses the prompt variable input as the search string in a LOCATE function.

SELECT
 CUSTID,
 CONAME,
 FNAME,
 LNAME,
 CITY
FROM
 SCDB1.CSTHDR CSTHDR
WHERE
 LOCATE( ' ' || &coname, CONAME ) <> 0

This will return only those records where the searched field contains the string entered in the prompt reply wtih a leading space added. If the input is 'abb' it will return a record containing ' abbreviate' but not 'cabbie'.

 

Ref#: 1483622

 

 

 

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: April 21, 2017