VistaDB 5
Gibraltar VistaDB / Developer's Guide / SQL Reference / Functions / System Functions
In This Topic
    System Functions
    In This Topic
    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)