Using 'not like' with exceptions

  • Thread starter Thread starter Renee
  • Start date Start date
R

Renee

I have a query that has a crieteria under UNIT # of 'Not Like 'S*'. I would
like to keep this criteria but add that certain unit #'s that do start with
'S' be shown. Is this possible? I would like it to say something like: Not
Like 'S*' except S307 and S309.

Thanks for the help in advance
 
Back
Top