Constant

is a signed or unsigned whole number compatible with INTEGER or SMALLINT data types, for example:

   -16746

      155

        5

is a signed or unsigned floating point number compatible with the FLOAT or REAL data types, for example:

   .2E-4

is a signed or unsigned fixed-point number compatible with the DECIMAL data type, for example:

     -15.99

   +1451.1

is a character string compatible with CHAR, VARCHAR, DATE, TIME, DATETIME, or INTERVAL data types. String constants are delimited by single quotation marks, for example:

   'DON''T JUMP!'

However, two single quotation marks in a row are interpreted as a single quotation mark, not as string delimiters.

is a string of hexadecimal digits 0 through 9 and A through F (the lowercase a through f are also accepted) compatible with the BINARY and VARBINARY data types. A HexadecimalString constant must be prefaced with the characters 0x, for example:

   0xFFFAB0880088343330FFAA7

   0x000V001231