Breaking a String apart

Question

Post reply

Breaking a String apart

dwilliscp

SSCrazy Eights

Points: 9270
More actions
July 2, 2012 at 8:42 am

#258282

Does SQL have something (like Pick) that will search a string, and then break the string apart by that char?
For example... using the underscore
asdl;kfj_doske
fjdkls_lkjd
into..
asdl;kfj
doske
fjdkls
lkjd

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736352 More actions · Answer 1

There is no function to do this, but you can write one using the PATINDEX/CHARINDEX functions and SUBSTRING.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 2

Yep.[/url]

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

dwilliscp (7/2/2012)
Does SQL have something (like Pick) that will search a string, and then break the string apart by that char?
For example... using the underscore
asdl;kfj_doske
fjdkls_lkjd
into..
asdl;kfj
doske
fjdkls
lkjd

Have you searched this site for delimited split routines?

This article is a greate place to start: http://www.sqlservercentral.com/articles/Tally+Table/72993/

dwilliscp SSCrazy Eights Points: 9270 More actions · Answer 4

Thanks folks.. I did do a search, but I was looking at SQL commands... for some reason never thought to search the way you suggested, thanks Lynn. 🙂

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 5

I would probably build a SQL CLR routine to do it. String manipulation is *almost* (YMMV) always faster when manipulating text this way. If you are only doing a little then probably not the way to go..

CEWII