How to Split a string by delimited char in SQL Server
|
sam
378
Points
48
Posts
|
Hi, How to Split a string by delimited char in SQL Server?
Views:
8748
Total Answered: 1 Total Marked As Answer: 1 Posted On: 01-Jun-2015 08:02 Share: 
|
Answers
|
Brian
2232
Points
14
Posts
|
Hi Sam, Use following function as: select * from dbo.SplitString('abc-xyz','-')
CREATE FUNCTION [dbo].[SplitString]
(
@SplitStr nvarchar(1000),
@SplitChar nvarchar(5)
)
RETURNS @RtnValue table
(
Data nvarchar(50)
)
AS
BEGIN
Declare @Count int
Set @Count = 1
While (Charindex(@SplitChar,@SplitStr)>0)
Begin
Insert Into @RtnValue (Data)
Select Data= ltrim(rtrim(Substring(@SplitStr,1,Charindex(@SplitChar,@SplitStr)-1)))
Set @SplitStr = Substring(@SplitStr,Charindex(@SplitChar,@SplitStr)+1,len(@SplitStr))
Set @Count = @Count + 1
End
Insert Into @RtnValue (Data)
Select Data = ltrim(rtrim(@SplitStr))
Return
END
Posted On:
01-Jun-2015 05:42
|
