SPLIT function

This is a port of the SPLIT function from Perl (or VBScript). It works the same way: pass a string anda separator, up to 4 characters long (you can change this),and the function returns a table with the elements.This version trims leading and trailling spaces of the elements, just for convenience.Example:SELECT    strvalFROM    master.dbo.SPLIT('a and b', […]

5 (1)

2003-06-13

203 reads

Blogs

What Agent Jobs are Running??

By

Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC

By

When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020

By

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

Read the latest Blogs

Forums

Simple query question

By Mysterio

I'm new to SQL and I'm struggling to return a result set which I...

Filtering an R Dataframe

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Filtering an R Dataframe

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers