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!?!