Focal Point
[CLOSED] How to generate "CONTAINS" in SQL

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3307030496

July 29, 2020, 12:15 PM
Brandon Andrathy
[CLOSED] How to generate "CONTAINS" in SQL
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,


WebFOCUS 8204
July 29, 2020, 01:05 PM
FP Mod Chuck
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.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
July 30, 2020, 11:52 AM
Brandon Andrathy
thanks Chuck. As always, appreciate your responses.


WebFOCUS 8204