Replace in T-SQL

I have a column named "Chain" in this this column has multiple values each seperated by a comma. Is there any way to remove or replace the last value, ie anything after the last comma.
johnywhiteAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
nito8300Connect With a Mentor Commented:
SUBSTRING(Status, 1, LEN(Status) - CHARINDEX(',', REVERSE(Status)))


123,456,789

the output will be 123,456
0
 
nito8300Commented:
status being a field that i tested with :)
0
 
johnywhiteAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.