SQL LIKE clause in Sqlserver

Anonymous User 2057 24 Nov 2015

i want to use LIKE clause How to use .

Anonymous User

Other

I am a content writter !

1 Answers

Anonymous User 24 Nov 2015

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 Customer
WHERE CustomerName LIKE 'a%'
GO
SELECT * FROM Customer
WHERE CustomerName LIKE '%a%'
Go
SELECT * FROM Customer
WHERE CustomerName LIKE 'a_'
Go
SELECT * FROM Customer
WHERE CustomerName LIKE '_a'
 GO
SELECT * FROM Customer
WHERE CustomerName LIKE '_a_'

forum

SQL LIKE clause in Sqlserver

Can you answer this question?

1 Answers