Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
SIGN functionThe SIGN function returns an indicator of the sign of the argument.

SIGN function

The SIGN function returns an indicator of the sign of the argument.

SIGN Function

If the argument is less than zero, -1 is returned. If the argument equals zero, 0 is returned. If the argument is greater than zero, 1 is returned. The result returned is always an integer with one of these values.