Like Operator

[Guest]

I want to use the LIKE operator in the WHERE clause of my query with the
column name of a table instead of a literal value with a wildcard character.
Anyone have ideas on how to do this?

 

[John Vinson]

I want to use the LIKE operator in the WHERE clause of my query with the
column name of a table instead of a literal value with a wildcard character.
Anyone have ideas on how to do this?

I'm not sure I see what you mean. How is the table you're searching
related to the table in "column name of a table"?

If you have two joined tables in a query, you can certainly use a
criterion of

LIKE "*" & [OtherTable].[FieldName] & "*"

but I'm not certain that's what you're getting at!

John W. Vinson[MVP]

 

[Guest]

That's exactly what I needed. Thanks!

I want to use the LIKE operator in the WHERE clause of my query with the
column name of a table instead of a literal value with a wildcard character.
Anyone have ideas on how to do this?

I'm not sure I see what you mean. How is the table you're searching
related to the table in "column name of a table"?

If you have two joined tables in a query, you can certainly use a
criterion of

LIKE "*" & [OtherTable].[FieldName] & "*"

but I'm not certain that's what you're getting at!

John W. Vinson[MVP]