Query criteria

I have a table that has the following values one per record

FD30, FD30S, None, FD60, FD60S, FD120 and FD120S

In a query I want to filter out the records with an "S" on the end leaving

FD30, None, FD60,  and FD120
Derek BrownMDAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
select * from tablex
where [field] not like "*S"
0
 
Rgonzo1971Commented:
HI

Maybe

SELECT Table1.[Field]
WHERE (((Table1.[Field]) Not Like "*FD##S*" And (Table1.[Field]) Not Like "*FD###S*"));

Regards
0
 
Derek BrownMDAuthor Commented:
Nice, simple. Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.