Neoview SQL Reference Manual (R2.4 SP2)

6 SQL Functions and Expressions................................................................................325
Categories............................................................................................................................................325
Standard Normalization................................................................................................................325
Aggregate (Set) Functions..............................................................................................................325
Character String Functions............................................................................................................326
Datetime Functions........................................................................................................................327
Mathematical Functions................................................................................................................328
Sequence Functions.......................................................................................................................329
Other Functions and Expressions..................................................................................................331
ABS Function.......................................................................................................................................332
Example of ABS.............................................................................................................................332
ACOS Function...................................................................................................................................333
Examples of ACOS........................................................................................................................333
ADD_MONTHS Function...................................................................................................................334
Examples of ADD_MONTHS........................................................................................................334
ASCII Function....................................................................................................................................335
Considerations for ASCII...............................................................................................................335
Example of ASCII..........................................................................................................................335
ASIN Function.....................................................................................................................................336
Examples of ASIN..........................................................................................................................336
ATAN Function...................................................................................................................................337
Examples of ATAN........................................................................................................................337
ATAN2 Function.................................................................................................................................338
Example of ATAN2........................................................................................................................338
AVG Function......................................................................................................................................339
Considerations for AVG.................................................................................................................339
Examples of AVG...........................................................................................................................339
BITAND Function...............................................................................................................................341
Considerations for BITAND..........................................................................................................341
Restrictions for BITAND................................................................................................................341
Examples of BITAND.....................................................................................................................341
CASE (Conditional) Expression..........................................................................................................342
Considerations for CASE...............................................................................................................343
Examples of CASE.........................................................................................................................343
CAST Expression.................................................................................................................................345
Considerations for CAST...............................................................................................................345
Valid Conversions for CAST .........................................................................................................345
Examples of CAST.........................................................................................................................345
CEILING Function..............................................................................................................................347
Example of CEILING.....................................................................................................................347
CHAR Function...................................................................................................................................348
Considerations for CHAR..............................................................................................................348
Example of CHAR.........................................................................................................................348
CHAR_LENGTH Function.................................................................................................................349
Considerations for CHAR_LENGTH............................................................................................349
Examples of CHAR_LENGTH......................................................................................................349
COALESCE Function..........................................................................................................................350
Example of COALESCE.................................................................................................................350
CODE_VALUE Function.....................................................................................................................351
Example of CODE_VALUE Function............................................................................................351
CONCAT Function..............................................................................................................................352
Concatenation Operator (||).........................................................................................................352
Considerations for CONCAT.........................................................................................................352
Examples of CONCAT...................................................................................................................352
10 Table of Contents