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.

mysql="Select * from table1 where (field1 like %" & inputstring & "%)"

--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
FrontPage Support: http://www.frontpagemvps.com/


"Mick" <(E-Mail Removed)> wrote in message
news:2754E87C-5228-4A3C-BD21-(E-Mail Removed)...
> 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.