Functions (SQL Server Compact)

Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5) supports functions.

Supported Functions

SQL Server Compact 3.5 supports the following functions.

  • Aggregate Functions
    Perform calculations on a set of values and return a single value. Except for the COUNT function, aggregate functions ignore null values.

    AVGAVG

    COUNT

    MAX

    MIN

    SUM

  • Date and Time Functions
    Perform an operation on a date and time input value and return a string, numeric, or date and time value.

    DATEADD

    DATEDIFF

    DATENAME

    DATEPART

    GETDATE

  • Mathematical Functions
    Perform calculations based on input values provided as parameters to the function and return a numeric value.

    ABS

    ACOS

    ASIN

    ATAN

    ATN2

    CEILING

    COS

    COT

    DEGREES

    EXP

    FLOOR

    LOG

    LOG10

    PI

    POWER

    RADIANS

    RAND

    ROUND

    SIGN

    SIN

    SQRT

    TAN

  • String Functions
    Perform an operation on a string input value and return a string or numeric value.

    NCHAR

    CHARINDEX

    LEN

    LOWER

    LTRIM_lce_ltrim

    PATINDEX

    REPLACE

    REPLICATE

    RTRIM

    SPACE_lce_space

    STR

    STUFF

    SUBSTRING

    UNICODE

    UPPER_lce_upper

  • System Functions
    Perform operations on, and return information about, values, objects, and settings in SQL Server Compact 3.5.

    @@IDENTITY

    COALESCE

    DATALENGTH