|
Operator |
This list allows you to select an operator between the property and the value for doing the search.
Stages of use:
Click the Operator column or select the desired operator from the drop-down window.
Like: This option allows you to make a partial comparison. The SQL (%) wildcard is used. Its use is identical to * in Windows. The wildcard % replaces any character chain, including an empty chain. The search "screw diameter Like %6" will have, as a result, screws with a diameter of 1.6, 6, 16, and 36.
Different: This operator allows you to do a search that is completely different from the criteria selected (all except). The search "screw diameter Different 6" will have, as a result, all screws except those with a diameter of 6.
Equal: The operator allows you to do a search that is equal strictly to the selected criteria. The search "screw diameter Equals 6" will have, as a result, all of the screws with a diameter of 6.
Less than: This operator allows you to do a search that is strictly less than the criteria selected. The search "screw diameter less than 6" will have, as a result, all screws with a diameter less than 6mm.
Less than or equal to: This operator allows to do a search that is smaller or equal to the selected criterion. The search "screw diameter less than or equal to 6" will have, as a result, all screws with a diameter less than or equal to 6mm.
Greater than: This operator allows you to do a search that is strictly greater than the selected criteria. The search "screw diameter Greater than 6" will have, as a result, all screws with a diameter greater than 6mm.
Greater than or equal to: operator allows you to do a search that is greater than or equal to the selected criterion. The search "screw diameter Greater than or equal to 6" will have, as a result, all screws with a diameter of 6mm or more.