Wild Card Concatenation With User Input

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

I am using an .adp file which is connected to the SQL
Server. I have created a query stored procedure. I now
am trying to search through one field, called NOTES, for
whatever the user inputs. In the criteria cell for the
column NOTES I type in:

LIKE "%" & @find & "%"

The % are the wildcards and find is basically the message
box that appears so the user can enter a phrase to search
for. This does not seem to work. Anybody have any
solutions. Thank You!
 
SQL Server uses plus (+) for concatenation and the apostrophe (') for
strings and date.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top