Link to home
Start Free TrialLog in
Avatar of SuperJinx
SuperJinx

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Ross Turner
Ross Turner
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SuperJinx
SuperJinx

ASKER

Worked. IN a nutshell lol. Cheers!