Could you please post DDL for table, some sample set and the expected O/P for the same ? This will help us understand and to work on the problem better.