1. Compile-time standard library

• String functions
  • SUBSTRING(),MID(),INSTR(),TRIM()
• Number functions
• Logical functions
• Date-time functions
  • CONVERT()
• Unique identified functions
  • NEWID(), UUID() and GEN_RANDOM_UUID()

2. Run-time standard library

• ROWNUM() (orROW_NUMBER())
• COALESCE()

3. [User-defined functions](User-defined functions)
4. Into-functions
5. From-functions
6. Aggregators
7. [User-defined aggregators](User-defined aggregators)

Samples:

    ABS(), IIF(), IFNULL(), INSTR(),LOWER(),UPPER(), LCASE(), UCASE(), LEN(), LENGTH()    YEAR(date), DAYOFWEEK(date)

• OBJECT_ID()