'like' w/ in the list of

[mdr227]

I want to do a query where I search for different phrases in a jobs title field. For example I want to pull everyone that has 'CFO', 'CEO', 'President', 'Partner', etc. in the title field. How can I do this w/ the like operator? Thanks.

 

[AshleyRickards]

In SQL the wildcard is the '%'. So something like this:
select * from table1 where title like '%CEO%' or like '%CFO%' .. and so on.

Ashley L Rickards
SQL DBA

 

[chiph]

If you're using MS Access, it doesn't use the ANSI standard '%' operator, so you'll have to use it's wildcard character, the asterisk '*'.

Chip H.