Ok, have tried [^a-zA-Z0-9], [^a-zA-Z0-9 ] (LIKE OR NOT LIKE), as well as PATINDEX('%[^a-zA-Z0-9]%',mycol) > 0
None of these exclude spaces and therefore always return valid entries- I want only those with non-numeric, non-alpha, and non-space. I know I have a record with HTML code in one varchar field. I also know I have special characters such as ?, #,*, ect.
Thanks for any assistance!