Difference in = and == in the Equation Editor

 

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