Michael Colling

All authors

DigitsOnlyEE and AlphaNumericOnly

by Michael Colling

SQLServerCentral.com

String Function

A nasty fast way to remove non-numeric and non-alphanumeric characters from a string

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.43 (7)

2019-03-15 (first published: 2016-05-17)

1,842 reads

Discuss

PatReplace8K

by Michael Colling

SQLServerCentral.com

T-SQL

This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

2017-03-24 (first published: 2015-05-16)

1,848 reads

Discuss

New T-SQL Fixed Width "Splitter"

by Michael Colling

SQLServerCentral.com

set-based

A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

2016-06-22 (first published: 2016-05-14)

1,422 reads

Discuss

PatExclude8K

by Michael Colling

SQLServerCentral.com

T-SQL

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.89 (9)

2016-06-10 (first published: 2014-10-27)

3,375 reads

Discuss

Translate function for SQL Server

by Michael Colling

SQLServerCentral.com

String Function

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.