Martin James

Martin James

  • 1.9k
  • 96
  • 2.3k

Difference between Equal and LIKE in T-SQL

Apr 15 2021 12:43 PM
I have the following query : 
 
  1. SELECT * FROM Employee  
  2. WHERE FullName LIKE '%James Martin%'   
and :
 
  1. SELECT * FROM Employe  
  2. WHERE FullName = 'James Martin'  
 
I want to know the difference between LIKE and = 

Answers (2)