Functions (SQL Server Compact Edition)

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) supports functions.

Supported Functions

SQL Server Compact Edition 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 Edition.

  @@IDENTITY

  COALESCE

  DATALENGTH