Neoview ODBC Drivers Manual (R2.2)

Table 5-11 Numeric Functions (continued)
SQL Equivalent FunctionODBC Function
COSHCOSH
Not supported in this release.COT
DEGREESDEGREES
EXPEXP
FLOORFLOOR
LOGLOG
LOG10LOG10
MODMOD
PIPI
POWERPOWER
RADIANSRADIANS
RANDRAND
Not supported in this release.ROUND
SIGNSIGN
SINSIN
SINHSINH
SQRTSQRT
TANTAN
TANHTANH
Not supported in this release.TRUNCATE
Table 5-12 String Functions
SQL Equivalent FunctionODBC Function
ASCIIASCII
CHARCHAR
CONCATCONCAT
Not supportedDIFFERENCE
INSERTINSERT
LOWERLCASE
SUBSTRINGLEFT
Supported, but no equivalent SQL function.LENGTH
LOCATE (ODBC LOCATE start parameter is not
supported.)
LOCATE
TRIM...LEADINGLTRIM
REPEATREPEAT
REPLACEREPLACE
RIGHTRIGHT
SQL Conformance Level 55