Table of Contents

1. Introduction of Functions in SQL Server 2005
   
   1.1 Built-in Functions
   
   
2. String Functions
   
   2.1 LEN (string)
   2.2 LTRIM (string)
   2.3 RTRIM (string)
   2.4 LEFT (string, length)
   2.5 RIGTH (string, length)
   2.6 SUBSTRING (string, start, length)
   2.7 REPLACE (search, find, replace)
   2.8 REVERSE (string)
   2.9 CHARINDEX (find, search [, start])
   2.10 PATINDEX (find, search [, start])
   2.11 LOWER (string)
   2.12 UPPER (string)
   2.13 SPACE (integer)
   
   
3. Numeric Functions
   
   3.1 ROUND (number, length, [function])
   3.2 ISNUMERIC(expressions)
   3.3 ABS (number)
   3.4 CEILING (number)
   3.5 FLOOR (number)
   3.6 SQUARE (float_number)
   3.7 SQRT (float_number)
   3.8 RAND ([seed])
   
   
4. Date/Time Functions
   
   4.1 GetDate ()
   4.2 GETUTCDATE()
   4.3 DAY (date)
   4.4 MONTH (date)
   4.5 YEAR (date)
   4.6 DATENAME (datepart, date)
   4.7 DATEPART(datepart, date)
   4.8 DATEADD (datepart, number, date)
   4.9 DATEDIFF (datepart, startdate, enddate)
   4.10 ISDATE (expression)
   
   
5. More Functions
   
   5.1 CASE
   5.2 COALESCE
   5.3 ISNULL
   5.4 GROUPING
   5.5 ROW_Number()
   5.6 RANK ()
   5.7 DENSE_RANK ()
   5.8 NTILE (integer_expression)
   5.9 ISNUMERIC