A Beginner’s Guide to SQL String Functions
Get an introduction to many of the many ways you can manipulate and interact with strings using SQL. Read on for more!
2019-12-18
String Function
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,698 reads
Translate function for SQL Server
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)
887 reads
Blogs
Daily Coping 10 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 9 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Refreshing a Power BI Dataset in Azure Data Factory
I recently needed to ensure that a Power BI imported dataset would be refreshed...
Forums
Migrate database with encrypted columns to SQL 2016
Hi all, I need to migrate a SQL 2012 database that has a few...
Controlling Intelligent Query Processing Features
Comments posted to this topic are about the item Controlling Intelligent Query Processing Features
To use the same function to pass table name as a parameter
I have this function, but I wanted to pass a table so as to...
Ask SSC