SQL String Archives - Page 8 of 12 - SQL Authority with Pinal Dave

SQL SERVER – Find First Non-Numeric Character from String

October 14, 2012

It is fun when you have to deal with simple problems and there are no out of the box solution. I am sure there are many cases when we needed the first non-numeric character from the string but there is no function available to identify that right away. Here is…

SQL SERVER 2012 – String Function CONCAT() – A Quick Introduction

September 16, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL String

In SQL Server 2012, there are two new string functions being introduced, namely: CONCAT(), FORMAT(). In this blog post we are going to learn about String Function CONCAT(). CONCAT takes a minimum of two arguments to concatenate them, resulting to a single string.

SQL SERVER – Concat Function in SQL Server – SQL Concatenation

November 25, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL String

Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2”. I had a great time delivering the session. During the session, we talked about SQL Server 2012 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though,…

SQL SERVER – Get Numeric Value From Alpha Numeric String – Get Numbers Only

September 25, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Stored Procedure, SQL String

I have earlier wrote article about SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only and it was very handy tool for me. Recently blog reader and SQL Expert Christofer has left excellent improvement to this logic. Here is his contribution. He…

SQL SERVER – Function to Retrieve First Word of Sentence – String Operation

August 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

I have sent of function library where I store all the UDF I have ever written. Recently I received email from my friend requesting if I have UDF which manipulate string and returns only very first word of the statement. Well, I realize that I do not have such a…

SQL SERVER – Finding the Occurrence of Character in String

August 16, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

This article is written in response to provide hint to TSQL Beginners Challenge 14. The challenge is about counting the number of occurrences of characters in the string. Here is quick method how you can count occurrence of character in any string. Here is quick example which provides you two…

SQLAuthority News – Converting a Delimited String of Values into Columns

February 10, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL String, SQL XML

This blog post is about two great bloggers and their excellent series of blog posts. It was quite unusual to see two bloggers posting articles that are supporting each other and constantly improving the articles to the next level. Two blogs which I am going to mention here are as…