---
title: "How to search title which contain single quote using LIKE operator in SQL Server?"  
description: "How to search title which contain single quote using LIKE operator in SQL Server?"  
author: "Revati S Misra"  
published: 2023-01-22  
updated: 2023-01-22  
canonical: https://www.mindstick.com/forum/157340/how-to-search-title-which-contain-single-quote-using-like-operator-in-sql-server  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 1 minute  

---

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

A [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) has a [column](https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server) [Title](https://www.mindstick.com/articles/12860/how-to-get-financing-for-salvage-title-cars) that contains many words with a single quote( ' ). When applying the LIKE [operator](https://www.mindstick.com/blog/144/union-intersection-and-except-operator-in-sql-server) to [match](https://www.mindstick.com/forum/159713/regex-match-attribute-in-an-html-code) that words it does not return any record. Help me to find a better solution to solve it.

## Replies

### Reply by Steilla Mitchel

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.

```diff
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?

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


---

Original Source: https://www.mindstick.com/forum/157340/how-to-search-title-which-contain-single-quote-using-like-operator-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.