Progress
SQL-92
Guide and Reference


Numeric Literals

A numeric literal is a string of digits that SQL interprets as a decimal number. SQL allows the string to be in a variety of formats, including scientific notation.

This is the syntax for a numeric_literal:

SYNTAX
[ + | - ] { [ 0-9 ] [ 0-9 ] ... }
    [ . [ 0-9 ] [ 0-9 ] ... ] 
    [ { E | e } [ + | - ][ 0-9 ] { [ 0-9 ] } ] 

EXAMPLE

The following numeric strings are all valid:

123
123.456
-123.456
12.34E-04 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095