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-28 (first published: )

2,472 reads

Blogs

Top 5 SQL Server VM Performance Tuning Tips – Webinar Jul 21

By

You’re invited! I’m thrilled to be co-presenting a session on the top five SQL...

The Effectiveness of Solar Estimation

By

We added a solar system to the ranch as a way to hedge against...

How do I tell if identity_insert is turned on and if so what table?

By

TLDR; The code to do this is below but it’s a bit hokey and...

Read the latest Blogs

Forums

Interview question to test beginner SQL competency?

By jintogens

Hello, I need to help my boss come up with a simple-ish SQL quiz....

Shared Work Spaces: Hell, Heaven, Both?

By Grant Fritchey

Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...

T-SQL : Slicing time Islands and gaps

By MrRobot

Hello, Consider the following table that gives the validity dates of an item :...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers