SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xxv
9. SQL/MX Functions and Expressions
LCASE Function 9-87
Examples of LCASE 9-87
LEFT Function 9-88
Examples of LEFT 9-88
LNNVL Function 9-89
Examples of LNNVL 9-90
LOCATE Function 9-91
Considerations for LOCATE 9-92
Examples of LOCATE 9-92
LOG Function 9-93
Examples of LOG 9-93
LOG10 Function 9-93
Examples of LOG10 9-93
LOWER Function 9-94
Considerations for LOWER 9-94
Examples of LOWER 9-98
LPAD Function 9-99
Examples of LPAD 9-99
LTRIM Function 9-102
Considerations for LTRIM 9-102
Examples of LTRIM 9-102
MAX Function 9-103
Considerations for MAX 9-103
Examples of MAX 9-103
MIN Function 9-104
Considerations for MIN 9-104
Examples of MIN
9-104
MINUTE Function 9-105
Examples of MINUTE 9-105
MOD Function
9-106
Examples of MOD
9-106
MONTH Function 9-107
Examples of MONTH
9-107
MONTHNAME Function
9-108
Examples of MONTHNAME
9-108
MOVINGAVG Function
9-109
Examples of MOVINGAVG 9-110
MOVINGCOUNT Function
9-111
Considerations for MOVINGCOUNT 9-112