SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Reference Manual—523725-004
xix
9. SQL/MX Functions and Expressions
9. SQL/MX Functions and Expressions
Categories 9-1
Aggregate (Set) Functions 9-1
Character String Functions 9-2
Datetime Functions 9-4
Mathematical Functions 9-5
Sequence Functions 9-7
Other Functions and Expressions 9-8
Table-Valued Stored Functions 9-9
ABS Function 9-10
Examples of ABS 9-10
ACOS Function 9-11
Examples of ACOS 9-11
ASCII Function 9-12
Examples of ASCII 9-12
ASIN Function 9-13
Examples of ASIN 9-13
ATAN Function 9-14
Examples of ATAN 9-14
ATAN2 Function 9-15
Examples of ATAN2 9-15
AVG Function 9-16
Considerations for AVG 9-16
Examples of AVG 9-17
CASE (Conditional) Expression 9-18
Considerations for CASE 9-19
Examples of CASE 9-20
CAST Expression 9-22
Considerations for CAST 9-22
Valid Conversions for CAST 9-22
Examples of CAST 9-23
CEILING Function 9-24
Examples of CEILING 9-24
CHAR Function 9-25
Examples of CHAR 9-25
CHAR_LENGTH Function 9-26
Considerations for CHAR_LENGTH 9-26
SQL/MP Considerations for CHAR_LENGTH 9-26
Examples of CHAR_LENGTH 9-27