Delimited Strings

Technical Article

Extract values from a string using a delimiter

  • Script

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)

You rated this post out of 5. Change rating

2011-11-28 (first published: )

2,603 reads

Blogs

Azure SQL offerings

By

There are three Azure SQL products with so many different deployment options, service tiers,...

T-SQL Tuesday #183 Roundup

By

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....

A Little Brainstorming with an AI

By

I was asked to do some a little thinking and brainstorming recently. Rather than...

Read the latest Blogs

Forums

Is Ransomware Fading?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Ransomware Fading?

How to Resolve SQL Server Database Stuck in Recovery Pending State

By Nisarg Upadhyay

Comments posted to this topic are about the item How to Resolve SQL Server...

A Simple Choice

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Simple Choice

Visit the forum

Question of the Day

A Simple Choice

I have this data in a table?

CatIDCatName
3Monitors
What is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS c
 

See possible answers