Functions in SQL

602SQL Client API Functions

Functions Defined by the SQL Standard (SQL)

The following functions defined by the SQL standard are implemented in 602SQL:

• POSITION - Searches for a substring within a string or text
• CHAR_LENGTH, OCTET_LENGTH, BIT_LENGTH - Returns the string length
• SUBSTRING - Selects a substring from a string or text
• UPPER, LOWER - Converts a character string or text into the specified case
• EXTRACT - Returns a component of the date or time
• CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP - Returns the actual date and time
• NULLIF - Compares expression values
• COALESCE - Returns the value of the first expression that is not NULL
• CAST - Converts a type into another type
• Aggregation functions (AVG, SUM, MIN, MAX and COUNT) - Calculates values over a record set

List of topics:

• POSITION Function
• CHAR_LENGTH, OCTET_LENGTH, BIT_LENGTH Functions
• SUBSTRING Function
• UPPER, LOWER Functions
• EXTRACT Function
• CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP Functions
• NULLIF Function
• COALESCE Function
• CAST Function
• Aggregate (Group) Functions

Functions in SQL

602SQL Client API Functions