---
title: "SQL LIKE clause in Sqlserver"  
description: "SQL LIKE clause in Sqlserver"  
author: "Anonymous User"  
published: 2015-11-24  
updated: 2015-11-24  
canonical: https://www.mindstick.com/forum/33632/sql-like-clause-in-sqlserver  
category: "database"  
tags: ["database", "sql server", "sql"]  
reading_time: 1 minute  

---

# SQL LIKE clause in Sqlserver

i want to use LIKE [clause](https://www.mindstick.com/forum/33937/difference-between-throw-exception-and-throw-clause) How to use .

## Replies

### Reply by Anonymous User

The SQL LIKE clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction with the LIKE operator:\
The percent sign (%)\
The underscore (_)\
The percent sign represents zero, one, or multiple characters. The underscore represents a single number or character. The symbols can be used in combinations.

```
SELECT * FROM CustomerWHERE CustomerName LIKE 'a%'GOSELECT * FROM CustomerWHERE CustomerName LIKE '%a%'GoSELECT * FROM CustomerWHERE CustomerName LIKE 'a_'GoSELECT * FROM CustomerWHERE CustomerName LIKE '_a' GOSELECT * FROM CustomerWHERE CustomerName LIKE '_a_'
```


---

Original Source: https://www.mindstick.com/forum/33632/sql-like-clause-in-sqlserver

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