SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxxiv
8. SQL/MX Functions and Expressions
ASCII Function 8-11
Examples of ASCII 8-11
ASIN Function 8-12
Examples of ASIN 8-12
ATAN Function 8-13
Examples of ATAN 8-13
ATAN2 Function 8-13
Examples of ATAN2 8-13
AVG Function 8-14
Considerations for AVG 8-14
Data Type of the Result 8-14
Operands of the Expression 8-14
Nulls 8-14
Examples of AVG 8-15
CASE (Conditional) Expression 8-16
Considerations for CASE 8-17
Data Type of the CASE Expression 8-17
Character Data Type 8-17
Numeric Data Type 8-18
Datetime Data Type 8-18
Interval Data Type 8-18
Examples of CASE 8-18
CAST Expression 8-20
Considerations for CAST 8-20
Valid Conversions for CAST 8-20
Examples of CAST 8-21
CEILING Function
8-22
Examples of CEILING 8-22
CHAR Function 8-23
Examples of CHAR
8-23
CHAR_LENGTH Function
8-24
Considerations for CHAR_LENGTH 8-24
CHAR and VARCHAR Operands
8-24
SQL/MP Considerations for CHAR_LENGTH
8-24
Similarity to OCTET_LENGTH Function
8-24
Examples of CHAR_LENGTH
8-25
COALESCE Function 8-27
Considerations
8-27
Examples of COALESCE 8-28