Home | User-Defined Functions | Tips & Tricks | SQL Server 2005 | Forums | Frequently Asked Questions | Practice Test |

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. 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. 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.