I have a pretty standard form where the user can enter data into one or more of several text boxes and search a database for info. I want to take this further by allowing the user to enter more than one search parameter within one text box separated by semi-colons. The best way to explain this is to show a simple example:
EG. Currently the user can enter all or part of an item number of a product. In the cfquery I use:
WHERE itemno like '%#item_number#%' . . . .
. . . . So, if they entered "12345" into the text box, the query would search for and return any item number containing "12345"
WHAT I NEED: is for the user to be able to enter more than 1 item number within the same text box separated by semi-colons:
How do I change my "WHERE" statement in the query so it will search for each item number found between the semi-colons? I know a little about lists, but cannot get this to work.