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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER