forum

Home / DeveloperSection / Forums / How to search title which contain single quote using LIKE operator in SQL Server?

Ask Question

How to search title which contain single quote using LIKE operator in SQL Server?

Revati S Misra 421 22-Jan-2023

A table has a column Title that contains many words with a single quote( ' ). When applying the LIKE operator to match that words it does not return any record. Help me to find a better solution to solve it. 

mssql server sql server  sql 
Updated on 22-Jan-2023
Revati S Misra

Revati S Misra

Follow
Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

Can you answer this question?

Answer

1 Answers

Steilla Mitchel

Steilla Mitchel

27-Jan-2023

There is the easiest way to find all records that contain single quotes is by using the LIKE operator. You can find all records that contain values with single quotes in a column by using the following SQL query.

To find all the records which contain single quotes then use below SQL query.

SELECT * FROM TabelName WHERE ColumnName LIKE'%''%'

 

To find specific records where single quotes are used with the specific word then use this given SQL query. E.g. What’s your plan?


SELECT * FROM TabelName WHERE ColumnName LIKE '%What''s%'

  

Liked By