Comparison Operators

The SAP ASE server uses these comparison operators:




Equal to


Greater than


Less than


Greater than or equal to


Less than or equal to


Not equal to


(Transact-SQL extension) Not equal to


(Transact-SQL extension) Not greater than


(Transact-SQL extension) Not less than

In comparing character data, < means closer to the beginning of the server’s sort order and > means closer to the end of the sort order. Uppercase and lowercase letters are equal in a case-insensitive sort order. Use sp_helpsort to see the sort order for your SAP ASE server. Trailing blanks are ignored for comparison purposes. So, for example, “Dirk” is the same as “Dirk ”.

In comparing dates, < means earlier and > means later.

Put single or double quotes around all character and datetime data used with a comparison operator:
= "Bennet" 
> "May 22 1947"