CONTAINS, reserved word

[Eugene]

Does MS Access 2000 support the SQL operator CONTAINS in a
SELECT statement, as in, SELECT * FROM table WHERE col
CONTAINS '%word%' ? I cannot get CONTAINS to work in MS
Access.

 

[GreySky]

Use LIKE.

.... LIKE "*word*"

David