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] Using a variable in a like statement
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Using a variable in a like statement
 Login/Join
 
Gold member
posted
I want to use a like statement in my report, but what the like is equal to depends on the user. What I currently have is

 TABLE FILE sp_failure_details
PRINT filename
      description
WHERE filename LIKE '&TEST'
END 


But it has to be an exact filename, not a like. I want something that looks like '123%' with '123' being the variable passed through by the user.

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


WebFOCUS 8.2.01M on Windows 7
 
Posts: 46 | Registered: July 30, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Append a % to the beginning and end of the variable so you can search for anything you want.

  
-SET &TEST='%'||&TEST||'%';
TABLE FILE CAR
PRINT CAR BY COUNTRY
WHERE CAR LIKE '&TEST';
END


WebFOCUS 8204, Unix, Windows
 
Posts: 1617 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
Thank you Babak! I knew there had to be a simple solution like that, but I just couldn't think of it. Guess I still have a lot to learn when it comes to WebFOCUS


WebFOCUS 8.2.01M on Windows 7
 
Posts: 46 | Registered: July 30, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Maybe more simple
TABLE FILE CAR
PRINT CAR BY COUNTRY
WHERE CAR CONTAINS '&TEST';
END


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2105 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
In case you want to go down the rabbit hole here's a comprehensive explanation of LIKE and CONTAINS. Interesting nuance.

https://webfocusinfocenter.inf...r/source/03PRM21.htm


WebFOCUS 8204, Unix, Windows
 
Posts: 1617 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
Originally posted by BabakNYC:
In case you want to go down the rabbit hole here's a comprehensive explanation of LIKE and CONTAINS. Interesting nuance.

https://webfocusinfocenter.inf...r/source/03PRM21.htm

Interesting the use of _ in a LIKE.
Similar as using WHERE EDIT(JOBCODE, '$9') EQ '1';

I'm wondering which syntax is the more performant...?


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2105 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Using a variable in a like statement

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