DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
1,952 reads
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
1,952 reads
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
2017-03-24 (first published: 2015-05-16)
1,856 reads
A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting
2016-06-22 (first published: 2016-05-14)
1,467 reads
Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)
2016-06-10 (first published: 2014-10-27)
3,425 reads
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.
2016-06-01 (first published: 2016-05-12)
905 reads
An inline table valued function (iTVF) that can be used to calculate age in years.
2016-04-27 (first published: 2016-04-06)
970 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Brian Kelley
Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation...
Hi. I am trying to download a report from SSRS 2019 in word format...
I've yet to find an answer for this. I've found a few queries that...