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: 

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Are YOU READY TO START LEARNING SQL SERVER, BUT DON'T KNOW WHERE TO START?

Nothing is worse than, being excited to learn a new tool but not knowing where to start, wasting time learning the wrong features, and being overwhelmed .

But it doesn't have to be this way.

I'm Putting together a free email course to help you get started learning SQL Server.

Name*
Email*
>