Thread: Filter results
View Single Post
  #1  
Old 2nd October 2017, 18:17
MIMOURI MIMOURI is offline
Junior Member
 
Join Date: Mar 2005
Posts: 5
MIMOURI is on a distinguished road
Baan: IV c4 - DB: Bisam - OS: HPUX
Filter results

Is there any possibility to filter results using as substring chain the content of a program variable?

for instance by using in a SELECT the statement

WHERE tiitm001.dsca LIKE %find%

any item containing in its description the chain "find" is displayed

But what if "find" is the value of a variable? Is there any way?

Thank you
Reply With Quote