I have a customer that sends data to a table.
I have no control over that process and how they buld their data
But it constantly comes in with 1 - 20 trailing commas
I want to trim all leading and trailing commas in SQL Server as it comes in
,,lbrister, ee-change, dog, cat, horse,,,,
lbrister, ee-change, dog, cat, horse