---
title: "How To Use Wildcard Characters in LIKE Operations?"  
description: "How To Use Wildcard Characters in LIKE Operations?"  
author: "Amit Singh"  
published: 2010-11-09  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/223/how-to-use-wildcard-characters-in-like-operations  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How To Use Wildcard Characters in LIKE Operations?

Wildcard character '%' can be used in the pattern string for the LIKE operator to match any string of zero or more characters.\
\
for example:\
\
SELECT c.CompName FROM Company c\
WHERE c.CompName LIKE '%Mind% Stick'\

## Answers

### Answer by Amit Singh

Wildcard character '%' can be used in the pattern string for the LIKE operator to match any string of zero or more characters.\
\
for example:\
\
SELECT c.CompName FROM Company c\
WHERE c.CompName LIKE '%Mind% Stick'\


---

Original Source: https://www.mindstick.com/interview/223/how-to-use-wildcard-characters-in-like-operations

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