I have a table called tmp_tbl that only has one column called field1.
I populate that column with a single comma delimited string that has approx 100 commas or splits
How can I get this one column to create 100 columns with each piece of delimited data?
I have looked at every possible split function and can't find one that I can get to work.
Thanks in advance!