How to Search For Names With Special Character in them in SQL?

special character in name

In my new project, I came across a scenario where the names like O’Neal was being retrieved as O&#Neal. I wanted to check the database if we have other names like that. May be in both first name and last name. So I start trying different SQL queries, such as Where First_Name Like ‘O%’ Problem…