Relative Content

Tag Archive for splittrim

string_split SQL Server

Thank you in advance for reviewing my question. I have a list of conditions, comma delimited, within a column and I’m trying to convert the list into rows within a SQL view, using string_split. Unfortunately, the list of conditions within the column are as follows: Contion1, Condition2, Condition3, … and are not: Condition1,Condition2,Condition3… As a result of the space after each comma, the string_split leave the space. I believe that I need to somehow trim the left to remove the space between the comma and the next condition, but it’s beating me at the moment. Again, thank you in advance for reviewing my question.