Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008
    Posts
    22

    Unanswered: TSQL version for split

    Hello,
    In our frontend script we can easily implement a split function using

    split(variable)

    How do i do this in TSQL. Bearing in mind, I have a csv string

    declare @string varchar(max)

    set @string = test,trial,csv,sally,mac

    set @string = split(@string)

    How do i achieve this ?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Check here: http://www.sqlteam.com/forums/topic....10&whichpage=1 and search for "CSV / Splitting delimited lists"
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2008
    Posts
    22
    Oh brilliant site. Seem easier to use

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by sallymac
    Oh brilliant site. Seem easier to use
    Well to you then
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •