When you enter anything in the Criteria cell or the Or cell, the is equal to (=) operator is assumed at the beginning of the text unless a different operator is specified. For example, if you enter Rotating Pump in the Criteria cell of a character field, Meridium Enterprise APM will assume that you want to return records where the value in that field is equal to Rotating Pump.
It is not necessary to enter the = operator at the beginning of the expression in a given cell. If you do not enter the operator, Meridium Enterprise APM will insert it automatically, but it will not be displayed. In addition, Meridium Enterprise APM inserts but does not display the text WHERE or HAVING before the beginning operator (either an implied = operator or an explicit alternate operator). This means that the SQL code will contain either a WHERE clause or a HAVING clause as a result of the text that you enter in the Criteria cell or the Or cell.
