Skip to Content
0
Former Member
Jul 03, 2006 at 04:09 PM

How can change the query where clause values in formatted search

24 Views

Hi

I have a formatted search with the below sql

Select ItemCode,ItemName from OITM

where ItemCode like 'FX%'

how can I change 'FX%' to another value

I tried to make it as paramter

where ItemCode like $[ItemCode]

but I am receiving an error

sincerely yours

Riade Asleh