Skip to Content
0
Former Member
May 14, 2008 at 09:04 PM

Parameters using like in record selection

20 Views

Post Author: sharonmtowler

CA Forum: General

I have a parameter BILL TO NAME, i would like the users to be able to use part of the name to retrieve the records. If the client name contains CHEMICAL i would like to retrieve all accounts that have chemical in there name somewhere, no standard position.

(if{?Bill Name}='ALL' then true else {?Bill Name} like {Pr_rel_ord_wait_ship;1.BILL_NAME}) i know i can use a wild card but i cant remember the syntax.

thanks