IN THIS CHAPTER
SQL Server Compact Edition supports built-in functions for counting, calculations, strings, and date manipulations. These functions are a subset function that SQL Server 2005 supports. The best way to learn the SQL Server Compact Edition built-in functions is to run the functions yourself and see the results.
Use the mathematical functions to operate numerical expressions. Mathematical functions operate on a numerical category data type. You can input float, real, integer, smallint, tinyint, and money.
The ABS (Absolute) mathematical function takes a numeric ...