Progress
SQL-92
Guide and Reference


Scalar Functions

This section listsProgress SQL-92 scalar functions. Table E–1 identifies the compatibility of the function as SQL-92 compatible, ODBC compatible, or a Progress extension.

Table E–1: Compatibility of SQL-92 Scalar Functions
Scalar Function
SQL-92
ODBC
Progress
Extension
Notes
ABS
ACOS
ADD_MONTHS
ASCII
ASIN
ATAN
ATAN2
CAST
CEILING
CHAR
CHR
COALESCE
CONCAT
CONVERT
Requires ODBC escape clause – { fn }
CONVERT
Not compatible with ODBC CONVERT
COS
CURDATE
CURTIME
DATABASE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DB_NAME
DECODE
DEGREES
EXP
FLOOR
GREATEST
HOUR
IFNULL
INITCAP
INSERT
INSTR
LAST_DAY
LCASE
LEAST
LEFT
LENGTH
LOCATE
LOG10
LOWER
LPAD
LTRIM
MINUTE
MOD
MONTH
MONTHNAME
MONTHS_BETWEEN
NEXT_DAY
NOW
NULLIF
NVL
 
PI
POWER
PREFIX
PRO_ARR_DESCAPE
PRO_ARR_ESCAPE
PRO_ELEMENT
QUARTER
RADIAN
RAND
REPEAT
REPLACE
RIGHT
ROUND
ROWID
RPAD
RTRIM
SECOND
SIGN
SIN
SQRT
SUBSTR
SUBSTRING
SUFFIX
SYSDATE
SYSTIME
SYSTIMESTAMP
TAN
TO_CHAR
TO_DATE
TO_NUMBER
TO_TIME
TO_TIMESTAMP
TRANSLATE
UCASE
UPPER
USER
WEEK
YEAR


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