Skip to main content

Difference in = and == in the Equation Editor

Hello Group Members,

 
The Equation Editor toolbar has two arithmetical operators ~ = and ==
 
= is to be used in a criteria (expression) when looking for a Character Field beginning with.
 
== is to be used in a criteria (expression) when looking for an exact match on the Character Field.
 
Let us understand this post with an example.
 
You have a file with field 'Item Description'. Some of the sample 'Item Description' are ~
 
Bearing 85 - 120Z
Bearing 95/zzz
Bearing Large
Shaft 9mm
 
Now if your requirement is to examine records where the 'Item Description' begins with Bearing then your criteria in the Equation Editor will be -
 
Item_Description = "Bearing"
 
On the other hand if you are looking to extract records where the 'Item Description' exactly equals to Bearing Large then your criteria in the Equation Editor will be -
 
Item_Description == "Bearing Large"
 
Best Regards
 
Group Admin Team