Thanks everyone for your help! I received a lot of great ideas so I ended up taking a piece from each and came up with this: Select (substr(scan(ovr_new_value,1,','),1,8)); when ('"WRKP_MI') Minutes = scan(ovr_new_value, 1, ','); when ('"WRKP_RE') TC = scan(ovr_new_value, 1, ','); when ('"WRKP_TC') TYPE = scan(ovr_new_value, 1, ','); end; Then repeated the above for the New2 and New3 columns. Works like a charm and does exactly what I want it to do. Again, thanks! You guys are awesome!!!
... View more