Find Names in the SQL Server Database with Special Characters

If your name fields has special characters like ~!@#$%^&*()-+":{} and so on, then here's a simple query that lets you find special characters in Names.

SELECT * FROM CustomersTemp

WHERE FirstName like '%[~!@%^&*()]%'

or LastName like '%[~!@%^&*()]%'