SQL BUILT-IN FUNCTIONS

COLUMN FUNCTION
AVG	Returns the average of a set of numbers
COUNT	Returns the number of rows or values in a set of rows or values
COUNT_BIG	Same as COUNT, except the result can be greater than the maximum value of an integer
MAX	Returns the maximum value in a set of values
MIN	Returns the minimum value in a set of values
STDDEV	Returns the standard deviation of a set of numbers
SUM	Returns the sum of a set of numbers
VARIANCE or VAR	Returns the variance of a set of numbers

SCALAR FUNCTION
ABS or ABSVAL Returns the absolute value of its argument ACOS Returns the arccosine of an argument as an angle, expressed in radians ASIN Returns the arcsine of an argument as an angle, expressed in radians ATAN Returns the arctangent of an argument as an angle, expressed in radians ATANH Returns the hyperbolic arctangent of an argument as an angle, xpressed in radians ATAN2 Returns the arctangent of x and y coordinates as an angle, expressed in radians BLOB Returns a BLOB representation of its argument CEIL or CEILING Returns the smallest integer greater than or equal to the argument CHAR Returns a fixed-length character string representation of its argument CLOB Returns a CLOB representation of its argument COALESCE Returns the first argument in a set of arguments that is not null CONCAT Returns the concatenation of two strings COS Returns the cosine of an argument that is expressed as an angle in radians COSH Returns the hyperbolic cosine of an argument that is expressed as an angle in radians DATE Returns a date derived from its argument DAY Returns the day part of its argument DAYOFMONTH Similar to DAY DAYOFWEEK Returns an integer in the range of 1 to 7, where 1 represents Sunday DAYOFYEAR Returns an integer in the range of 1 to 366, where 1 represents January 1 DAYS Returns an integer representation of a date DBCLOB Returns a DBCLOB representation of its argument DECIMAL or DEC Returns a decimal representation of its argument DEGREES Returns the number of degrees for an argument that is expressed in radians DIGITS Returns a character string representation of a number DOUBLE Returns a double precision floating-point representation of its argument EXP Returns the exponential function of an argument FLOAT Same as DOUBLE FLOOR Returns the largest integer that is less than or equal to the argument GRAPHIC Returns a GRAPHIC representation of its argument HEX Returns a hexadecimal representation of its argument HOUR Returns the hour part of its argument IFNULL Returns the first argument in a set of two arguments that is not null INSERT Returns an argument inserted into another at the same position where some bytes have been deleted INTEGER or INT Returns an integer representation of its argument JULIAN_DAY Returns an integer that represents the number of days from January 1, 4712 B.C. LCASE or LOWER Returns a string with the characters converted to lowercase LEFT Returns a string that consists of the specified number of leftmost bytes of a string LENGTH Returns the length of its argument LN Same as LOG LOCATE Returns the position at which the first occurrence of an argument starts within another argument LOG Returns the natural logarithm of an argument LOG10 Returns the base 10 logarithm of an argument LTRIM Returns the characters of a string with the leading blanks removed MICROSECOND Returns the microsecond part of its argument MIDNIGHT_SECONDS Returns an integer in the range of 0 to 86400 that represents the number of seconds between midnight MINUTE Returns the minute part of its argument MOD Returns the remainder of one argument divided by second argument MONTH Returns the month part of its argument NULLIF Returns NULL if the arguments are equal; else the first argument POSSTR Returns the position of the first occurrence of an argument within another argument POWER Returns the value of one argument raised to the power of a second argument QUARTER Returns an integer in the range of 1 to 4 that represents the quarter of the year for the date specified RADIANS Returns the number of radians for an argument that is expressed in degrees RAISE_ERROR Raises an error in the SQLCA with the specified SQLSTATE and error description RAND Returns a double precision floating-point random number REAL Returns a single precision floating-point representation of its argument REPEAT Returns a character string composed of an argument repeated a specified number of times REPLACE Returns a string in which all occurrences of an argument within a second replaced with a third argument RIGHT Returns a string that consists of the specified number of rightmost bytes of a string ROUND Returns a number rounded to the specified number of places to the right or left of the decimal place ROWID Returns a row ID representation of its argument RTRIM Returns the characters of an argument with the trailing blanks removed SECOND Returns the second part of its argument SIGN Returns the sign of an argument SIN Returns the sine of an argument that is expressed as an angle in radians SINH Returns the hyperbolic sine of an argument that is expressed as an angle in radians SMALLINT Returns a small integer representation of its argument SPACE Returns a string that consists of the number of blanks the argument specifies SQRT Returns the square root of its argument STDDEV Returns the standard deviation of a set of numbers STRIP Returns the characters of a string with the blanks at the beginning, end, or both of the string removed SUBSTR Returns a substring of a string TAN Returns the tangent of an argument that is expressed as an angle in radians TANH Returns the hyperbolic tangent of an argument that is expressed as an angle in radians TIME Returns a time derived from its argument TIMESTAMP Returns a timestamp derived from its arguments TIMESTAMP_FORMAT Returns a timestamp for a character, using a specified format to interpret the string TRANSLATE Returns a string with one or more characters translated TRUNCATE or TRUNC Returns a number truncated to the specified spaces to the right/left of the decimal UCASE or UPPER Returns a string with the characters converted to uppercase VALUE Same as COALESCE VARCHAR Returns the varying-length character string representation of its argument VARCHAR_FORMAT Returns a character string of a timestamp, with the string in a specified format VARGRAPHIC Returns a graphic string representation of its argument WEEK Returns an integer that represents the week of the year YEAR Returns the year part of its argument

He that takes the devil into his boat must carry him over the sound.