I'm trying to obtain a distinct list of special characters a particular field in my database.
In SQL I am using the WHERE clause:
LIKE '%[^0-9a-zA-Z ]%'
What I need to do is loop through the results and grab only the special characters contained within so I can have a full list of the characters and send them to a supplier.
Can anyone recommend a quick way to do this? I can export my SQL results to a text file so no requirement for database connectivity.