A collation function that converts characters to the EXACT collation format.
expression) %EXACT expression
|A string expression, which can be the name of a column, a string literal, or the result of another function, where the underlying data type can be represented as any character type (such as CHAR or VARCHAR2).|
The EXACT collation sequence for strings is the same as the ANSI-standard ASCII collation sequence: digits are collated before uppercase alphabetic characters and uppercase alphabetic characters are collated before lowercase alphabetic characters. Punctuation characters occur at several places in the sequence.
You can perform the same collation conversion in ObjectScript using the Collation() method of the
The following examples uses
%EXACT to return all Name values that are higher in the collating sequence than 'Smith'. The first example uses parentheses syntax, the second omits the parentheses.
SELECT Name FROM Sample.Person WHERE Name > 'Smith'
SELECT Name FROM Sample.Person WHERE %EXACT(Name) > 'Smith'
SELECT Name FROM Sample.Person WHERE %EXACT Name > 'Smith'