Parameters in SQL queries using "contains" or "like"
 

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


--
StuartAberdein
------------------------------------------------------------------------
StuartAberdein's Profile: http://www.excelforum.com/member.php...o&userid=35664
View this thread: http://www.excelforum.com/showthread...hreadid=554468