WILDCARDS in Queries

[jasonbarnes]

What is the correct syntax to use wildcards around a field name?



Example : WHERE tblName.MarksDescription like '*(tblCHS.Marks)*';

Do you put () around the field name? This does not seem to work. I get 0 matches. I want the query to find the tblCHS.Marks as a substring within the MarksDescription field. I haven't tried anything else. All examples are seaching for one particular string such as "ABC"

Thanks!?!

[jasonbarnes]

The only other variation I see is

* & tblCHS.Marks & *;