Progress SQL-92 Guide and Reference
SQL-92 Functions Table 4–1: Progress SQL-92 Aggregate Functions AVG Function COUNT Function MAX Function MIN Function SUM Function – Table 4–2: Progress SQL-92 Scalar Functions ABS Function ACOS Function ADD_MONTHS Function ASCII Function ASIN Function ATAN Function ATAN2 Function CASE Function CAST Function CEILING Function CHAR Function CHR Function COALESCE Function CONCAT Function CONVERT Function (ODBC Compatible) CONVERT Function (Progress Extension) COS Function CURDATE Function CURTIME Function DATABASE Function DAYNAME Function DAYOFMONTH Function DAYOFWEEK Function DAYOFYEAR Function DB_NAME Function DECODE Function DEGREES Function EXP Function FLOOR Function GREATEST Function HOUR FUNCTION IFNULL Function INITCAP Function INSERT Function INSTR Function LAST_DAY Function LCASE Function LEAST Function LEFT Function LENGTH Function LOCATE Function LOG10 Function LOWER Function LPAD Function LTRIM Function MINUTE Function MOD Function MONTH Function MONTHNAME Function MONTHS_BETWEEN Function NEXT_DAY Function NOW Function NULLIF Function NVL Function PI Function POWER Function PREFIX Function PRO_* Functions QUARTER Function RADIANS Function RAND Function REPEAT Function REPLACE Function RIGHT Function ROUND Function ROWID Function RPAD Function RTRIM Function SECOND Function SIGN Function SIN Function SQRT Function SUBSTR Function SUBSTRING Function (ODBC Compatible) SUFFIX Function SYSDATE Function SYSTIME Function SYSTIMESTAMP Function TAN Function TO_CHAR Function TO_DATE TO_NUMBER Function TO_TIME Function TO_TIMESTAMP Function TRANSLATE Function UCASE Function UPPER Function USER Function WEEK Function YEAR Function