• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

I am trying to use a charlist wildcard to select surnames that do not begin with WGP but the code i am using is just doing the exact opposite!

So basically, i want to select surnames that do not begin with W, G or P my code is:

SELECT * FROM Person WHERE LastName LIKE '[!wgp]%'

and it is just brining up the surnames that DO start with these letters, quite irritating

Thanks for any help.
0
SuperJinx
Asked:
SuperJinx
1 Solution
 
Ross TurnerManagement Information Support AnalystCommented:
Try:
SELECT * FROM Person WHERE LastName not LIKE '[!wgp]%'
0
 
SuperJinxAuthor Commented:
Worked. IN a nutshell lol. Cheers!
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now