... pretend the info we want is rather simple:
SELECT
[sequenceID],
[student_reference],
[student_title_code],
[student_name],
[student_gender_code],
...
... circumflex/hat to negate the expression in the first example, and then the use of NOT LIKE in the second example:
SELECT * FROM [STUDENTS] WHERE [S_SURNAME] LIKE '%[^a-zA-Z0-9]%'
-- returns all rows ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.