query to look for and pull only records w certain text

[taylornow]

Hello everybody - I was going to look at the boards and see if this question was there - but to be honest - I had no idea what keyword to use. Here goes -
I have a database listing projects. The project name for each is very similiar- each special in a slightly different way. What I need is a query just pulling out the ones with certain words or letters within the name. In my case - the letters are CD. I need a list of all the projects with the name CD in them. Sometimes it is in the front and sometimes in the middle of the name. I don't even know where to start. Someone give me a push.

Thanks in advance
Taylor

 

[Yesca]

select * from [Projects] where (Instr([ProjectName], 'CD') > 0);

 

[taylornow]

Okay - here goes - thanks a bunch

T.

 

[taylornow]

It Worked !! You are the best - Thanks so much.

Taylor

 

[WildHare]

Or select * from [Projects] where
[ProjectName] LIKE "*CD*"

Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm