How do you translate the following sql code to WebFOCUS code?
select goremal_email_address from goremal
where goremal_email_address like '%uncg.edu';

Thank you,
Chris

TABLE FILE GOREMAL
PRINT GOREMAL_EMAIL_ADDRESS
WHERE GOREMAL LIKE '%uncg.edu';

You may wish to search the Technical Documenation Library linked above and to the right for
Types of record selection tests

HTH

quote:

WHERE GOREMAL LIKE '%uncg.edu';

Or you can use

WHERE GOREMAL CONTAINS 'uncg.edu';