Wednesday, February 10, 2010

Split function in sql server 2000 or sql server 2005

declare @value nvarchar(50)
declare @splitter nvarchar(50)
declare @delimit nvarchar(1)
select
@delimit = '/'
select
@splitter = 'Any Section/Department A'
SET
@value = SUBSTRING(@splitter,1,CHARINDEX(@delimit,@splitter)-1)
--For Previous string to the delimeter
select
@value as retSplittedValue
--For Next string to the delimeter
select substring(@splitter,(len(@value)+2),(len(@splitter))-len(@value))

No comments:

Post a Comment