ASP SELECT Syntax question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a variable called INPUTSTRING. I have an access table called TABLE1
with a field called FIELD1. I want to select all records that have a word
similar to INPUTSTRING in FIELD1. What is the correct syntax of the select
statement? Is it
Select * from table1 where field1 like %inputstring%

Thanks for any replies.
 
Back
Top