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     [SOLVED] LIKE IN Operator
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] LIKE IN Operator
 Login/Join
 
Gold member
posted
I remember seeing something like this in the past, which worked. Does it really reliably exist?

WHERE &var LIKE IN ('%thing1%','%thing2%')

This message has been edited. Last edited by: mbondr,


WebFOCUS 8.2.04 (and climbing)
Windows, All Outputs
 
Posts: 81 | Registered: February 08, 2018Reply With QuoteReport This Post
Master
posted Hide Post
I don't see that syntax in the language reference. The only reference to using multiple masks is the an IF statement.
To search for records with the LIKE operator, use 

IF field LIKE 'mask1' [OR 'mask2'...]To reject records based on the mask value, use 

IF field UNLIKE 'mask1' [OR 'mask2' ...]


If it worked in the past you may be a victim of code tightening.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 923 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Okay. As jgelona said, this is the syntax:

APPT_LOCATION_DISP NOT LIKE 'APIA%' OR 'CHU%' OR 'EAT%' OR . . .


WebFOCUS 8.2.04 (and climbing)
Windows, All Outputs
 
Posts: 81 | Registered: February 08, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] LIKE IN Operator

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