Can an Access database be searched?

  • Thread starter Thread starter Bruce W.1
  • Start date Start date
B

Bruce W.1

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 said:
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?
Click to expand...

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
 
Back
Top