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,795 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)
897 reads
Blogs
Welcome to 3Cloud …
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
Daily Coping 23 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
One Thousand SQL Saturdays (*ish)
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
Forums
Need help to form query to get missing month data
I want to know what are the customers having missing month data based on...
What would cause slow disk access on an AWS EBS SQL Server? (PAGELATCHIO_SH)
I have an EC2 instance (r5a.4xlarge) which should be able to do 2Gbps+ in...
What's Causing the Pushback with DevOps?
Comments posted to this topic are about the item What's Causing the Pushback with...
Ask SSC