Less Than Operator
Description: Tests two operands and returns TRUE if the left hand value is less than the right hand value. The two operands must be of the same type. Data types allowed are integer and float.
Symbol: <
Example:
3<9 returns TRUE (1)
3<2 returns FALSE (0)
Salary<50000, in a source field, would place a 1 in the target field for all records which were less than 50000 and a 0 for all records which were greater than 50000.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*