[AccessD] query expression help

Hey guys....

I'm blanking.  If I want to create an expression, in a query, that
checks another field for specific text....ie:

Check field [ProfitCenterName] with value of:

Associates Retail Balto.Architecture

....to see if "Architect" is within the text...and if so, return a value
of "21".......

How do I do this?  I've got a query, I want to check the text within
another field....to see if certain text is buried within the value of
that field...and if so, populate the expression I am building in the
query.

Thanks,

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com