• Thanks for the replay.

    I am having almost 600 records, so is there any other way to get the result without case statement.