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
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,
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.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
thanks Chuck. As always, appreciate your responses.
|Powered by Social Strata|