Hello,

I'm aware of the CONTAINS key word in FOCUS Code. However, when I generate sql using CONTAINS.

 

TABLE FILE CAR
BY COUNTRY
WHERE COUNTRY CONTAINS 'England'
END

 

It generates

 
WHERE COUNTRY LIKE '%England%'
 

I'd like SQL to generate:

 

WHERE COUNTRY CONTAINS 'England'

 

Does anyone have an idea how to do this?

This message has been edited. Last edited by: Brandon Andrathy,

Brandon

WebFOCUS translates to ANSI standard SQL and I don't think CONTAINS is ANSI standard. You should be able to code it yourself and use SQL Passthru.

thanks Chuck. As always, appreciate your responses.