SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
xix
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
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-10
Examples of ACOS 9-10
ASCII Function 9-11
Examples of ASCII 9-11
ASIN Function 9-12
Examples of ASIN 9-12
ATAN Function 9-13
Examples of ATAN 9-13
ATAN2 Function 9-13
Examples of ATAN2 9-13
AVG Function 9-14
Considerations for AVG 9-14
Examples of AVG 9-15
CASE (Conditional) Expression 9-16
Considerations for CASE 9-17
Examples of CASE 9-18
CAST Expression 9-20
Considerations for CAST 9-20
Valid Conversions for CAST 9-20
Examples of CAST 9-21
CEILING Function 9-22
Examples of CEILING 9-22
CHAR Function 9-23
Examples of CHAR 9-23
CHAR_LENGTH Function 9-24
Considerations for CHAR_LENGTH 9-24
SQL/MP Considerations for CHAR_LENGTH 9-24
Examples of CHAR_LENGTH 9-25
CODE_VALUE Function 9-27
Considerations for CODE_VALUE Function 9-27
CONCAT Function 9-28
Concatenation Operator (||) 9-28