Home User-Defined Functions Tips & Tricks SQL Server 2005 SQL Server 2008 FAQ Forums Practice Test Bookstore

String Functions Count Character Occurrence Returns the number of times a given input character exists in a given input string. Count String Occurrence Returns the number of times a given search string exists in a given input string. Count Words Returns the number of words in a given input string. InitCap / String Capitalization Emulates the behavior of Oracle's InitCap string function, which changes the first letter of each word in uppercase and all others in lowercase. Simple String Encryption/Decryption A string encryption and decryption function that uses a simple algorithm to encrypt and decrypt string values. Trim Leading Zeros Trims the leading zeros of an alphanumeric value.   Date Functions Get Age Computes for the age given the birth date and the reference date. Determine Leap Year Determines whether the input date is a leap year or not. Get First Day of the Week Returns the first day of the week for a given date. Get First Day of the Month Returns the first day of the month for a given date. Get First Day of the Quarter Returns the first day of the quarter for a given date. Get Last Day of the Month Returns the last day of the month for a given date. Get Date Only Returns the input date removing the time portion. Get Number of Days in a Month Returns the number of days in a month. Get Number of Days in a Year Returns the number of days in a year.   Tree Functions Get Tree Path Returns the path of a node from the parent to the current node in a hierarchical/tree-type table. Get Tree Node Level Returns the level of a given node in a hierarchical/tree-type table.   Table-Valued Functions Integer Range Table Returns a table containing integer values from 1 to a maximum value. Comma-Delimited Value to Table Returns a table containing the comma-delimited value parameter as separate records.