DEC() Function - Binary Integer to Decimal

Syntax

DEC (string)

Description

The DEC() function converts a binary string argument into a numeric value. The string argument is treated as a signed binary integer. A null string argument, DEC(''), will return 0.

The BIN() function performs the reverse of the DEC() function, given the same string size as the original argument.

Example

Select DEC(MYSTRING) from MYTABLE