Hi
I have column with repeating value which I want to fix as follows.
Tbl_A
Col_1
225
221,222
41-45, 49
332-337, 211, 63-66
where (41-45) means 41,42,43,44,45 etc.
& (221,222) means 221 and 222
332-337, 211, 63-66 means both above
I want to overcome these repairing values by adding the separate rows (with same values of other columns) for each value.
Please advise how to build a procedure / function for that which can understand (‘-‘ & ‘,’).
Wishes
Jawad