4D v14

SIGN

Home

 
4D v14
SIGN

SIGN  


 

 

 Command SIGSIGN (arithmetic_expression)

The SIGN function returns the sign of the arithmetic_expression (e.g., 1 for a positive number, -1 for a negative number or 0).

Example  

This example will returns all the negative amounts found in the INVOICES table:

SELECT AMOUNT
FROM INVOICES
WHERE SIGN(AMOUNT) = -1;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)