I pass a string to my stored procedure that can be setup in different formats. I trying to use Trim, replace, CharIndex and such to format it in a way I can use. Here is what the string usually looks like when passing:
'Widget1, Widget2, Widget3
Widget4, Widget5, Widget6
It might be hard to tell from this but say after Widget3 there are a bunch of spaces. This is what I need the string to look like:
'Widget1, Widget2, Widget3, Widget4, Widget5, Widget6, Widget7, Widget8'
so a coma after each widget or remove all comma and have one single space. either would work