Contents Index Data types in UltraLite Dynamic SQL

UltraLite Database User's Guide
  SQL Language Elements

UltraLite SQL functions

The following is a convenient reference for finding functions in dynamic SQL. Each function is listed, and the function type (numeric, character, and so on) is indicated next to it.

For information about functions in Adaptive Server Anywhere, see SQL Functions.

Function Remarks 
ABS (
numeric-expression )
 See ABS function [Numeric] 
ACOS (
numeric-expression )
 See ACOS function [Numeric] 
ARGN (
integer-expression,
expression [ , ...] )
 See ARGN function [Miscellaneous] 
ASCII (
string-expression )
 See ASCII function [String] 
ASIN (
numeric-expression )
 See ASIN function [Numeric] 
ATAN (
numeric-expression )
 See ATAN function [Numeric] 
{ ATN2 | ATAN2 } (
numeric-expression1,
numeric-expression2 )
 See ATN2 function [Numeric] 
AVG (
numeric-expression
| DISTINCT column-name )
 DISTINCT column-name cannot be used from dynamic SQL.

See AVG function [Aggregate]

 
BYTE_LENGTH (
string-expression )
 See BYTE_LENGTH function [String] 
BYTE_SUBSTR (
string-expression,
start [, length ] )
 See BYTE_SUBSTR function [String] 
CAST (
expression AS data type )
 See CAST function [Data type conversion] 
CEILING (
numeric-expression )
 See CEILING function [Numeric] 
CHAR (
integer-expression )
 See CHAR function [String] 
CHARINDEX (
string-expression1,
string-expression2 )
 See CHARINDEX function [String] 
CHAR_LENGTH (
string-expression )
 See CHAR_LENGTH function [String] 
COALESCE (
expression,
expression [ , ...] )
 See COALESCE function [Miscellaneous] 
CONVERT (
data-type,
expression
[ , format-style ] )
 See CONVERT function [Data type conversion] 
COS (
numeric-expression )
 See COS function [Numeric] 
COT (
numeric-expression )
 See COS function [Numeric] 
COUNT (
 * | expression
| DISTINCT
{ expression
 column-name } )
 DISTINCT column-name cannot be used from dynamic SQL.

See COUNT function [Aggregate]

 
DATALENGTH (
expression )
 See DATALENGTH function [System] 
DATE (
expression )
 See DATE function [Date and time] 
DATEADD (
date-part,
numeric-expression,
date-expression )
 See DATEADD function [Date and time] 
DATEDIFF (
date-part,
date-expression1,
date-expression2 )
 See DATEDIFF function [Date and time] 
DATEFORMAT (
datetime-expression,
string-expression )
 See DATEFORMAT function [Date and time] 
DATENAME (
date-part,
date-expression )
 See DATENAME function [Date and time] 
DATEPART (
date-part,
date-expression )
 See DATEPART function [Date and time] 
DATETIME (
expression )
 See DATETIME function [Date and time] 
DAY (
date-expression )
 See DAY function [Date and time] 
DAYNAME(
date-expression )
 See DAYNAME function [Date and time] 
DAYS (
[datetime-expression,]
datetime-expression )
 See DAYS function [Date and time] 
DAYS (
datetime-expression,
integer-expression )
 See DAYS function [Date and time] 
DEGREES (
numeric-expression )
 See DEGREES function [Numeric] 
DIFFERENCE (
string-expression-1,
string-expression-2 )
 See DIFFERENCE function [String] 
DOW (
date-expression )
 See DOW function [Date and time] 
EXP (
numeric-expression )
 See EXP function [Numeric] 
FLOOR (
numeric-expression )
 See FLOOR function [Numeric] 
GETDATE ()
 See GETDATE function [Date and time] 
GREATER (
expression1,
expression2 )
 See GREATER function [Miscellaneous] 
HEXTOINT (
hexadecimal-string )
 See HEXTOINT function [Data type conversion] 
HOUR (
datetime-expression )
 See HOUR function [Date and time] 
HOURS (
[ datetime-expression, ]
datetime-expression )
 See HOUR function [Date and time]See HOURS function [Date and time] 
HOURS (
datetime-expression,
integer-expression )
 See HOUR function [Date and time]See HOURS function [Date and time] 
IFNULL (
expression-1,
expression-2
[ , expression-3 ] )
 See IFNULL function [Miscellaneous] 
INSERTSTR (
integer-expression,
string-expression-1,
string-expression-2 )
 See INSERTSTR function [String] 
INTTOHEX (
integer-expression )
 See INTTOHEX function [Data type conversion] 
ISDATE (
string )
 See ISDATE function [Data type conversion] 
ISNULL (
expression,
expression [ , ... ] )
 See ISDATE function [Data type conversion] 
LCASE (
string-expression )
 See LCASE function [String] 
LEFT (
string-expression,
para-expression
 See LEFT function [String] 
LENGTH (
string-expression )
 See LENGTH function [String] 
LESSER (
expression1,
expression2 )
 See LESSER function [Miscellaneous] 
LIST (
{ string-expression
 | DISTINCT column-name }
[ , delimiter-string ]
[ ORDER BY
 order-by-expression ] )
 DISTINCT column-name cannot be used from dynamic SQL.

See LIST function [Aggregate]

 
LOCATE (
string-expression-1,
string-expression-2
[, integer-expression ] )
 See LOCATE function [String] 
LOG (
numeric-expression )
 See LOG function [Numeric] 
LOG10 (
numeric-expression )
 See LOG10 function [Numeric] 
LOWER (
string-expression )
 See LOWER function [String] 
LTRIM (
string-expression )
 See LOWER function [String] 
MAX (
expression
| DISTINCT column name )
 See MAX function [Aggregate] 
MIN (
expression
| DISTINCT column name )
 See MIN function [Aggregate] 
MINUTE (
datetime-expression )
 See MINUTE function [Date and time] 
MINUTES (
[ datetime-expression, ]
datetime-expression )
 See MINUTES function [Date and time] 
MINUTES (
datetime-expression,
integer-expression )
 See MINUTES function [Date and time] 
MOD (
dividend,
divisor )
 See MOD function [Numeric] 
MONTH (
date-expression )
 See MONTH function [Date and time] 
MONTHNAME (
date-expression )
 See MONTHNAME function [Date and time] 
MONTHS (
[ datetime-expression, ]
datetime-expression )
 See MONTHNAME function [Date and time] 
MONTHS (
datetime-expression,
integer-expression )
 See MONTHNAME function [Date and time] 
NEWID( )
 This function is not supported by the UltraLite static Java API.

See NEWID function [Miscellaneous]

 
NOW ( * )
 See NOW function [Date and time] 
NULLIF (
expression-1,
expression-2 )
 See NULLIF function [Miscellaneous] 
PATINDEX (
'%pattern%',
string_expression )
 See PATINDEX function [String] 
PI ( * )
 See PI function [Numeric] 
POWER (
numeric-expression-1,
numeric-expression-2 )
 See POWER function [Numeric] 
QUARTER (
date-expression )
 See QUARTER function [Date and time] 
RADIANS (
numeric-expression )
 See RADIANS function [Numeric] 
REMAINDER (
dividend,
divisor )
 See REMAINDER function [Numeric] 
REPEAT (
string-expression,
integer-expression )
 See REPEAT function [String] 
REPLACE (
original-string,
search-string,
replace-string )
 See REPLACE function [String] 
REPLICATE (
string-expression,
integer-expression )
 See REPLICATE function [String] 
RIGHT (
string-expression,
integer-expression )
 See RIGHT function [String] 
ROUND (
numeric-expression,
integer-expression )
 See ROUND function [Numeric] 
RTRIM (
string-expression )
 See RTRIM function [String] 
SECOND (
datetime-expression )
 See SECOND function [Date and time] 
SECONDS (
[ datetime-expression, ]
datetime-expression )
 See SECONDS function [Date and time] 
SECONDS (
datetime-expression,
integer-expression )
 See SECONDS function [Date and time] 
SIGN (
numeric-expression )
 See SIGN function [Numeric] 
SIMILAR (
string-expression-1,
string-expression-2 )
 See SIMILAR function [String] 
SIN (
numeric-expression )
 See SIN function [Numeric] 
SOUNDEX (
string-expression )
 See SOUNDEX function [String] 
SPACE (
integer-expression )
 See SPACE function [String] 
SQRT (
numeric-expression )
 See SQRT function [Numeric] 
STR (
numeric-expression
[, length
  [, decimal ] ] )
 See STR function [String] 
STRING (
string-expression
[, ...] )
 See STRING function [String] 
STRTOUUID (
string-expression )
 This function is not supported by the UltraLite static Java API.

See STRTOUUID function [STRING]

 
STUFF (
string-expression1,
start,
length,
string-expression2 )
 See STUFF function [String] 
{ SUBSTRING | SUBSTR }(
string-expression,
 start
[, length ] )
 See SUBSTRING function [String] 
SUM (
expression
| DISTINCT column-name )
 DISTINCT column-name cannot be used from dynamic SQL.

See SUM function [Aggregate]

 
TAN (
numeric-expression )
 See TAN function [Numeric] 
TODAY ( * )
 See TODAY function [Date and time] 
TRIM (
string-expression )
 See TRIM function [String] 
"TRUNCATE" (
numeric-expression,
integer-expression )
 See TRUNCATE function [Numeric] 
TRUNCNUM (
numeric-expression,
integer-expression )
 See TRUNCNUM function [Numeric] 
UCASE (
string-expression )
 See UCASE function [String] 
UPPER (
string-expression )
 See UPPER function [String] 
UUIDTOSTR(
uuid-expression )
 This function is not supported by the UltraLite static Java API.

See UUIDTOSTR function [STRING]

 
WEEKS (
[ datetime-expression, ]
datetime-expression )
 See WEEKS function [Date and time] 
WEEKS (
datetime-expression,
integer-expression )
 See WEEKS function [Date and time] 
YEAR (
[ datetime-expression, ]
datetime-expression )
 See YEARS function [Date and time] 
YEARS (
datetime-expression,
integer-expression )
 See YEARS function [Date and time] 
YMD (
integer-expression,
integer-expression,
integer-expression )
 See YMD function [Date and time]

Contents Index Data types in UltraLite Dynamic SQL