Technical Article

Extract values from a string using a delimiter

There are many occasions in programs where you need to manipulate strings of characters that are delimited by a particular character, such as a comma, or a space. This function enables you to extract a substring from the string at a specified occurence of the delimter. declare @Data varchar(255) set @Data = 'A,B,C,D,E' print dbo.field(@data,',',2,2) […]

4.17 (6)

2011-11-07 (first published: )

2,457 reads

Blogs

A New Form of Address: Mx

By

When I was presenting at the dataMinds Connect conference, I called on someone in...

Group By Starting Characters

By

I was chatting with Jeff (b|t) on my team yesterday and the context escapes...

Daily Coping 22 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Maybe It Is DNS

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Maybe It Is DNS

Finding all logins that can alter DDL

By webrunner

Hello experts, Is there a ready-made query out there that I could run on...

Insert records with a where

By saintor1

I want to insert record job allocations only for selected jobs I know the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers