1)
declare @string varchar(100)='ab,cd,ef,'
set @string= reverse (stuff(reverse(@string), 1, 1, ''))
print @string
2) declare @string varchar(100)='ab,cd,ef,'
set @string=
SUBSTRING(@string,1,LEN(ISNULL(@string,''))-1);
print @string
3) declare @string varchar(100)='ab,cd,ef,'
set @VARDAYTAS= LEFT(@VARDAYTAS,nullif(LEN(@VARDAYTAS)-1,-1))
print @string
o/p
ab,cd,ef
No comments:
Post a Comment