NishiNidhi73
MIS
Hi All,
User would like to search for customer names that starts with 'A%' or 'WAN%' or 'AMERI%' etc. Is it possible to use in operator with like operator?
Normally, in a query we use
where ((CustName like 'A%') or (CustName like 'WAN%') or (CustName like 'AMERI%'))
How do we get this in a prompt? I can't use Search prompt because there are more than 50000 customers.
Please advise.
Thanks for your help!!
Swathi
User would like to search for customer names that starts with 'A%' or 'WAN%' or 'AMERI%' etc. Is it possible to use in operator with like operator?
Normally, in a query we use
where ((CustName like 'A%') or (CustName like 'WAN%') or (CustName like 'AMERI%'))
How do we get this in a prompt? I can't use Search prompt because there are more than 50000 customers.
Please advise.
Thanks for your help!!
Swathi