Scalar Functions
You can use scalar functions in SQL statements with the following syntax:
{fn
scalar-function
}
where
scalar-function
is a scalar function supported by the Pervasive PSQL ADO.NET Data Provider.
Example:
SELECT {fn UCASE(NAME)} FROM EMP
Table
68
lists the scalar functions supported.
Table 68
Scalar Functions Supported
String
Functions
Numeric Functions
Timedate
Functions
System
Functions
ASCII
BIT_LENGTH
CHAR
CHAR_LENGTH
CHARACTER_LENGTH
CONCAT
LCASE or LOWER
LEFT
LENGTH
LOCATE
LTRIM
OCTET_LENGTH
POSITION
REPLACE
REPLICATE
RIGHT
RTRIM
SPACE
STUFF
SUBSTRING
UCASE or UPPER
ABS
ACOS
ASIN
ATAN
ATAN2
CEILING
COS
COT
DEGREES
EXP
FLOOR
LOG
LOG10
MOD
PI
POWER
RADIANS
RAND
ROUND
SIGN
SIN
SQRT
TAN
TRUNCATE
CURDATE
CURRENT_DATE
CURTIME
CURRENT_TIME
CURRENT_TIMESTAMP
DAYNAME
DAYOFMONTH
DAYOFYEAR
EXTRACT
HOUR
MINUTE
MONTH
MONTHNAME
NOW
QUARTER
SECOND
TIMESTAMPADD
TIMESTAMPDIFF
WEEK
YEAR
DATABASE
USER