I have stuck at my SELECT statement. I am looking for an Item by code and definition. I have a select statement like below...
select * from t_items where code ='#itemcode#' OR definition like '%#definition#%'
the user can select the #itemcode# from a dropdown menu on the web screen, or the user enters a test into the definition textbox. Because of the "LIKE", it returns everything.
what is the good way of doing this?