Neoview SQL Reference Manual (R2.3)

Examples of LOCATE....................................................................................................................362
LOG Function......................................................................................................................................363
Example of LOG............................................................................................................................363
LOG10 Function..................................................................................................................................364
Example of LOG10.........................................................................................................................364
LOWER Function................................................................................................................................365
Considerations for LOWER...........................................................................................................365
Example of LOWER.......................................................................................................................369
LPAD Function....................................................................................................................................370
Examples of LPAD.........................................................................................................................370
LTRIM Function..................................................................................................................................371
Considerations for LTRIM.............................................................................................................371
Result of LTRIM........................................................................................................................371
Example of LTRIM.........................................................................................................................371
MAX/MAXIMUM Function................................................................................................................372
Considerations for MAX................................................................................................................372
Operands of the Expression.....................................................................................................372
Example of MAX............................................................................................................................372
MIN Function......................................................................................................................................373
Considerations for MIN.................................................................................................................373
Operands of the Expression.....................................................................................................373
Example of MIN.............................................................................................................................373
MINUTE Function...............................................................................................................................374
Example of MINUTE.....................................................................................................................374
MOD Function....................................................................................................................................375
Example of MOD...........................................................................................................................375
MONTH Function...............................................................................................................................376
Example of MONTH......................................................................................................................376
MONTHNAME Function...................................................................................................................377
Example of MONTHNAME..........................................................................................................377
MOVINGAVG Function......................................................................................................................378
Example of MOVINGAVG............................................................................................................378
MOVINGCOUNT Function................................................................................................................379
Considerations for MOVINGCOUNT...........................................................................................379
No DISTINCT Clause...............................................................................................................379
Example of MOVINGCOUNT.......................................................................................................379
MOVINGMAX Function.....................................................................................................................381
Example of MOVINGMAX...........................................................................................................381
MOVINGMIN Function......................................................................................................................382
Example of MOVINGMIN............................................................................................................382
MOVINGSTDDEV Function...............................................................................................................383
Example of MOVINGSTDDEV......................................................................................................383
MOVINGSUM Function.....................................................................................................................385
Example of MOVINGSUM............................................................................................................385
MOVINGVARIANCE Function..........................................................................................................386
Example of MOVINGVARIANCE.................................................................................................386
NULLIF Function................................................................................................................................388
Example of NULLIF.......................................................................................................................388
NULLIFZERO Function......................................................................................................................389
Examples of NULLIFZERO...........................................................................................................389
NVL Function......................................................................................................................................390
Examples of NVL...........................................................................................................................390
OCTET_LENGTH Function................................................................................................................391
Considerations for OCTET_LENGTH...........................................................................................391
CHAR and VARCHAR Operands............................................................................................391
16 Table of Contents