iSeries Stored Procedure Help

[Brandon Stout]

Daniel wrote:

> We are using php on a linux box to call a stored procedure on an
> iSeries v5r2 to get data.  We have been unsuccessful in using LIKE in
> the WHERE clause and using '%' as a wildcard when used in-line.  What
> should we use for wildcards?
>
> -Daniel 

Do you have quote marks around the term, including the wildcard? Eg:

  SELECT * FROM t1 WHERE c1 LIKE "%term%";

Also, what database are you using?

Brandon Stout
http://mscis.org