Alex Jizrawi wrote:
> 
> Greetings,
> 
> I wanted to know if there was a way to combine variables and wildcards
> using the Report Writer .if statement.
> 
> for example if I have a variable string = "Joe" and I want to
> search for a text table that has the word Joe in it could I
> do something like
> 
> .if (text = "*$string*") .then ...
> 

Try

if locate('Joe',string) < length(string) then
  found = true;
endif;

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William