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))
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment