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!
Posted on 2013-01-29
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.