How to trim the last "," of a String? 2

[royc75]

Hello,

I have a String at this format: 1,2,3,...
It's size varies, so it could be 1,2, or 1,2,3,4,5,
The String always ends with "," and I would like to trim the last ",". How can I do it using SQL Functions?

 

[r937]

update datable
   set dacolumn = left(dacolumn,len(dacolumn)-1)
 where right(dacolumn,1) = ','

r937.com | rudy.ca

 

[bborissov]

declare @test varchar(200)
set @test = '1,2,3,4,5,'
SELECT CASE WHEN RIGHT(@test,1) = ',' THEN LEFT(@Test,LEN(@test)-1) ELSE @test END

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[royc75]

Thank you both for the quick response!