A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting
Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.
An inline table valued function (iTVF) that can be used to calculate age in years.
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)