Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to generate "CONTAINS" in SQL
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] How to generate "CONTAINS" in SQL
 Login/Join
 
Platinum Member
posted
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
 
Posts: 138 | Registered: July 10, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1993 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
thanks Chuck. As always, appreciate your responses.


WebFOCUS 8204
 
Posts: 138 | Registered: July 10, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to generate "CONTAINS" in SQL

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.