How can I search for strings containing a non-alphanumeric character or space?

Question

I want to look for a table for all rows that contain a non-letter and non-spatial character in a specific field. What I still have:

SELECT *
FROM myTable
WHERE myField LIKE '%[^a-zA-Z0-9]%'

As far as I can tell, this returns all non-alphanumeric fields. However, spaces are fine, so I don't want to return strings where the only non-alphanumeric character is space. How to configure this request?

Answer 1

How about adding space:

SELECT *
FROM myTable
WHERE myField LIKE '%[^a-zA-Z0-9 ]%'