Loading lesson path
Concept visual
Start at both ends
Return the sign of a number:
SELECT Sgn(243.5) AS SgnNum;The Sgn() function returns the sign of a number. This function will return one of the following:
Formula
If number > 0, it returns 1
If number = 0, it returns 0
If number < 0, it returns - 1number )
Required. The number to return the sign for❮ MS Access Functions