HI Jayakumars,
If ("Life is a Race " =true)
{
"Then CHASE it, BREAK it , :) below is your solution "
}
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @id varchar(10), @final varchar(max)=''
select @id=substring('1. |Jaya|R|Kumar| ',0,charindex('.','1. |Jaya|R|Kumar| '))
set @final=substring('1. |Jaya|R|Kumar| ',charindex('.','1. |Jaya|R|Kumar| ')+1,len('1. |Jaya|R|Kumar| '))
declare @site as varchar(max)
set @site = @final
declare @names as varchar(MAX)
set @final=''
while charindex('|',@site) > 0
BEGIN
select @names=substring(@site,1,(charindex('|',@site)-1))
set @final=@final+' '+@names
SET @site = substring(@site,charindex('|',@site)+1,len(@site))
END
print RTRIM(@id)+' '+LTRIM(@final)
Thanks & Regards
By
Rakesh patil
Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator