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 '%[~!@%^&*()]%'

Did you like this post?

	subscribe via rss		subscribe via e-mail
	print this post		follow me on twitter

Feedback: