MS Query - Order No beginning with W but does not contain a '/'

[Ben171]

Hi There i am new to using MS Query, i think this should be a very simple answer.

I am looking to display all of the order numbers that are beginning with W, but do not include those with a '/' in the order number.

I started by doing Like 'W%' which works for the first part. How do i then edit this to not include order numbers with a slash?

 

[RoryA]

You could use something like:

Like 'W%' And Not Like '%/%'

 

[Ben171]

You could use something like:

Like 'W%' And Not Like '%/%'

That worked perfectly thank you! knew it would be simple, i forgot to add the % before and after the /

whoops!