HOW TO USE LIKE Operator IN SQL SERVER.

Question

HOW TO USE LIKE Operator IN SQL  SERVER.

Anonymous User · Answer

The LIKE operator is used to list all rows in a table whose column values match a specified pattern. It is useful when you want to search rows to match a specific pattern, or when you do not know the entire value. For this purpose we use a wildcard character '%'.

SELECT * FROM Customer
WHERE CustomerName LIKE 'ad%';

forum

HOW TO USE LIKE Operator IN SQL SERVER.

Can you answer this question?

1 Answers