The following are functions supported by VistaDB.

CAST ( expression AS data_type [ ( length ) ] )

ISNULL ( check_expression, replacement_value )

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

Simple CASE function:

CASE input_expression 
     WHEN when_expression THEN result_expression 
    [ ...n ] 
     [ 
    ELSE else_result_expression 
     ] 
END 

Searched CASE function:

CASE
     WHEN boolean_expression THEN result_expression 
    [ ...n ] 
     [ 
    ELSE else_result_expression 
     ] 
END

CONTAINS ( searched_expression, find_expression )

LASTIDENTITY ( column_name [ , table_name ] )

LASTTIMESTAMP ( 'table_name' )

COALESCE ( expression, n )

NEWID ( )

SP_RENAME ( 'object_name', 'new_name', 'object_type' )

NULLIF (expression, expression)