How to remove last comma from csv file and add string in to it in SQL
server 2012
I have csv file in SQL
@code varchar(10) = 'pc-shr,pqr,qzcx,rtde,rz-fg,kj-hl,jk_lm'
I tried
Convert(Varchar(10), @code) + CASE WHEN len(@code) >10 THEN '..etc' Else
'' END [code]
but I want like this means to find last comma in a string and after that
add ..etc it should look like this
'pc-shr,pqr, ..etc'
No comments:
Post a Comment