MS Sql Server Tutorials | Examples | Interview Questions Tutorial

MS SQL Server LIKE Operator

❮ Previous Next ❯

expression LIKE pattern

Wildcard	Explanation
%	Represent zero or more characters
-	Represent a single character
[ ]	Represent any character in the [ ] brackets

SELECT * FROM [University].[dbo].[Student] WHERE Name LIKE 'S%';

SELECT * FROM Student WHERE Name LIKE '_avi';

SELECT * FROM Student WHERE Name LIKE '[RS]avi';

SELECT * FROM [University].[dbo].[Student] WHERE Name NOT LIKE'S%';

❮ Previous Next ❯