​​​​SQL Equals Comparison Operator

The SQL Equals comparison operator (=) is used to compare two values.  It returns a TRUE if the first value is equal the second. 

Here are a couple of examples: 

10 = 5 FALSE
5 = 5 TRUE
‘M’ = ‘F’ FALSE

Here is an example using Equals (=) to find all male employees 

SELECT NationalIDNumber, JobTitle, MaritalStatus,Gender FROM  HumanResources.Employee WHERE  Gender = 'M'
SELECT NationalIDNumber,
       JobTitle,
	   MaritalStatus,Gender
FROM   HumanResources.Employee
WHERE  Gender = 'M'

Additional Resources 

To learn more about SQL Equals (=), check out these useful resources: 

Are you ready to learn SQL Server, but don't know where to start?

>