If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Can an Access database be searched?
"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. :-/ |
#3
|
|||
|
|||
Can an Access database be searched?
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. |
Thread Tools | |
Display Modes | |
|
|