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

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 was, I could not give like First_Name Like ‘O’%’, that simply does not work, as you already know. So, what would work is First_name Like ‘%”%’. And that worked like charm, use the same to look for last name too.