Query Syntax to determine if the value of one field is in other fi

[Guest]

Hi,

I'm having a brain blip - in a query I would like to test if the value from
one field (example: Field 1: "ANN" Field 2: "ANN SMITH") is contained in
another field of the same table. If it weren't a field I would use LIKE.

Thanks in advance.

Bonnie

 

[Guest]

OOPS - don't want to waste anyone's time - I figured it out. I made a
calculated field in the query that is the result of
INSTR(table.field1,table.field2) with the criteria >0 and it works fine.

Thanks.