Re: Using the LIKE feature within a SELECT in Embedded SQL for RPG

Pat,

Use % catenated with the search string.  If you don't care about trailing
characters use % at the end of your search string.  If you don't care about
leading characters put % in front of your search string.  So, for your
example, to search for CANADIAN anywhere in the search field use %CANADIAN%
as the text in pname.

You'll also need to reverse the fields in the select statement.  The search
string should follow the LIKE instead of in front of it - wnname like
:pname.

Paul

-- 
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333

Pat wrote

>     I am tring to use the LIKE function within my SELECT statement, and am
> having some
>     trouble with it.
>     Both my prompt field and field I want to search are 30a.
>     Ex:  I key "CANADIAN" on the prompt and want to return to my subfile
> any
>     records with "CANADIAN COAST GUARD" and "MOLSON CANADIAN" and "THE
>     CANADIANS WIN HOCKEY GOLD AGAIN".
>     c/exec sql
>
>     c+ declare maincursor cursor for select * from wmmstr where
>     c+ :pname like wmname order by wmname
>     c/end-exec
>
>     Thanks,
>     Pat.