| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Web queries & Yahoo! Finance | Excel Discussion (Misc queries) | |||
| Too few parameters | Excel Discussion (Misc queries) | |||
| too few parameters | Excel Discussion (Misc queries) | |||
| Excel Queries with subqueries and parameters | Excel Discussion (Misc queries) | |||
| Parameters are not allowed in queries that can't be displayed grap | Excel Discussion (Misc queries) | |||
Linear Mode
