Abs

Table of Contents

Overview
Prototype

Example

See also
Related

Returns the absolute value of a number.

Numeric Abs(Numeric value)

Returns 5.5.

SELECT Abs(-5.5) as Result FROM Single

Scalar Functions

Basic KBSQL syntax and some examples.

Returns the value converted to lower case.

SQL :: ToNumeric

Returns the value converted to a number.

SQL :: ToProper

Returns the value with the first letter of each word capitalized (title case).

SQL :: ToString

Returns the number as a string, so that + concatenates it instead of adding it.

Returns the value converted to upper case.

Removes white space from the start and end of the value. When characters is given, each of those characters is removed from the start and end instead.