Post

Martin James

NA
100
14k

Difference between Equal and LIKE in T-SQL

Apr 15 2021 12:43 PM

I have the following query :

SELECT * FROM Employee
WHERE FullName LIKE '%James Martin%'

and :

SELECT * FROM Employe
WHERE FullName = 'James Martin'

I want to know the difference between LIKE and =

Answers (2)

Differences between INNER JOIN and INNER JOIN with a subquery

Openquery inside an openquery