Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

Abs

Example

Provide the absolute value of a number:

SELECT Abs(-243.5AS AbsNum;

Definition and Usage

The Abs() function yields the absolute (positive) value of a number.

Syntax

Abs(number)

Parameter Values

Parameter

Description

number

Required: A numeric input.

Technical Details

Works in:

 From Access 2000