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'
To learn more about SQL Equals (=), check out these useful resources: