Every day when I woke up there are hundreds of emails with various questions related to SQL. I spend my first hour of the day answer each of them.
How do I search records with single quotes in it?
Here is the answer to find records with single quotes in the table.
SELECT [ProductModelID] ,[Name] FROM [AdventureWorks2014].[Production].[ProductModel] WHERE [Name] LIKE '%''%' GO
Do let me know if there is any other way to find records with single quotes in it.
Reference: Pinal Dave (https://blog.sqlauthority.com)