Not
Åtkomst till denna sida kräver auktorisation. Du kan prova att logga in eller byta katalog.
Åtkomst till denna sida kräver auktorisation. Du kan prova att byta katalog.
Returns the positive (+1), negative (-1), or zero (0) sign of a numeric expression.
Syntax
SIGN(numeric_expression)
Arguments
- numeric_expression
Is a valid signed numeric expression. For more information, see Integration Services Data Types.
Result Types
DT_I4
Remarks
SIGN returns a null result if the argument is null.
Expression Examples
This example returns the sign of a numeric literal. The return result is -1.
SIGN(-123.45)
This example returns the sign of the result of subtracting the StandardCost column from the DealerPrice column.
SIGN(DealerPrice - StandardCost)