Delimited Strings

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)

2011-11-07 (first published: )

2,454 reads

Blogs

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Daily Coping 23 Oct 2020

By

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

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Read the latest Blogs

Forums

How to encode the following dynamical SQL scripts

By 892717952

I use one table (call first table) field's value to update another another table...

SQL Server Phone Home

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Phone Home

A Strange Comparison

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Strange Comparison

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers