S
StuartAberdein
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
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