SQL Server User-Defined Date Functions

• Count Character Occurrence Function

  ---

  Returns the number of times a particular character occurs in an input string.

• Count String Occurrence Function

  ---

  Returns the number of times a particular string occurs within another string.

• Count Words Function

  ---

  Returns the number of times a particular string occurs within another string.

• Encode / Decode String Function

  ---

  Returns the input string with the first letter of each word capitalized emulating Oracle's INITCAP string function.

• InitCap / String Capitalization Function

  ---

  Returns the input string with the first letter of each word capitalized emulating Oracle's INITCAP string function.

• Query String Parser Function

  ---

  Parses a query string input and returns the key-value pairs as a table.

• Trim Leading Zeros Function

  ---

  Trims the leading zeros of an alphanumeric value.