SUBSTRING

Equivalent Oracle's INSTR Function in SQL server

Oracle Built in Function INSTR is a great function if you wish to locate a string or a subset of string in the nth place.

Split String Function

This In-line Table Valued Function returns a table with individual records parsed from a string.

Format Currency Into a String

I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.