quote:

---

Originally posted by senthil_nagore

You want this?

declare @a varchar(25)
Set @a= '1,2,3,4,5'

print replace(@a,',',Char(10))


Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008

---

REPLACE(@a, ',', CHAR(13) + CHAR(10))

quote:

---

Originally posted by Transact Charlie

it isn't a new line character. it's a line feed.

If you are on windows (which you probably are!) then the proper way to end lines is {CARRIAGE RETURN}+{LINE FEED}

(it's different on unix btw)

So you should probably do

REPLACE(@a, ',', CHAR(13) + CHAR(10))

OP :

Did you really want only to display the results in printed format.

Or did you want to produce an output table by splitting the string?


Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

---

DECLARE @myTable TABLE (
    [MyKey] INT PRIMARY KEY
    , [MyVal] VARCHAR(8000)
    )
INSERT @myTable ([MyKey], [MyVal])
      SELECT 1, 'a,b,c'
UNION SELECT 2, 'foo,bar'

MyKey | Pos | Value
------+-----+------------
1     | 1   | a
1     | 2   | b
1     | 3   | c
2     | 1   | foo
2     | 2   | bar

SELECT
    a.[MyKey]
  , b.[Postion]
  , b.[Value]
FROM
    @MyTable AS a
    CROSS APPLY dbo.fnSplit(a.[MyVal]) AS b