Those columns smell as if something that should have been a set of values in a table was serialized instead.
Depending on the overall circumstances and permissions, could you build a function to tear it apart in to the necessary temp tables and use those to clean up the query in the current stored procedure?
Depending on the overall circumstances and permissions, could you build a function to tear it apart in to the necessary temp tables and use those to clean up the query in the current stored procedure?