I am trying to build a query to a MS_SQL database that uses parameters with a "contains" i.e. so that the user can enter a serial number as 1234 and find 01234 or 1234-8
If I don't use a parameter I can enter the query as Like '%1234%' and things work fine. However whan I try it as Like '%[Enter Serial]%' or Like '[%Enter Serial%]' then it doesn't work.
Can anybody help me.
Thanks