natcmp()

Function group	Execute on client	Platform(s)
String	NO	All

Syntax

natcmp(value1,value2)

Description

Returns the result of comparing two values using the national sort ordering. Returns 0 if the strings are equal, 1 if value1 > value2, and -1 if value1 < value2.

Both values are converted to strings before the comparison is made. natcmp() uses the same rules for comparing the strings as it does for normal strings, except that it uses the national sort ordering.

Example

Calculate
 
lResult
 as 
natcmp
(
lValue1
,
lValue2
)

# returns 0 if values are equal