splitting a delimited list into an "array" with T-SQL
Posted on 2012-03-23
I can find umpteen articles on the web about getting around the "array problem" in T-SQL. But I'm looking for a solution that's the easiest.
Picture a SQL table containing delimited text strings laid out basically like so:
Option 1=10;Something Else=20;Other=99
I want to parse this, first by semicolon delimiters, then by the = sign into key-value pairs.
What's the easiest way to do this that YOU use?
Thanks for the help.