Can an Access database be searched?

Using a SQL statement, can a Microsoft Access database be searched for a
word in a column (amongst other words in the cell)? SQL Server has a
'CONTAINS' SQL statement. Can this be used with Access?

Thanks for your help.

"Bruce W.1" wrote in message
...
Using a SQL statement, can a Microsoft Access database be searched for a
word in a column (amongst other words in the cell)? SQL Server has a
'CONTAINS' SQL statement. Can this be used with Access?

You can probably use the CONTAINS keyword in a pass-through SQL command to
an SQL Server database. As for using it against an Access table, you're
limited to LIKE as far as I know. The difference between the two is that
CONTAINS does a proximity search of words in a column whereas LIKE searches
for a string match at the beginning, end or middle of a column. But you
probably already knew that. :-/

You cau use the Like operator with wild cards like:

SELECT *cient.
FROM Table1
WHERE [SearchField] Like "*WhatYouSearchFor*"

Alternatively, you can use the InStr() function but "Like" in more effi

--
HTH
Van T. Dinh
MVP (Access)




"Bruce W.1" wrote in message
...
Using a SQL statement, can a Microsoft Access database be searched for a
word in a column (amongst other words in the cell)? SQL Server has a
'CONTAINS' SQL statement. Can this be used with Access?

Thanks for your help.