hi,
guys
i have query which given below output given below

manager personlevel person name
2085 1 Howard Wilson1
2085 2 Howard Wilson2
2085 3 Howard Wilson3
2085 4 Howard Wilson4
2085 5 Howard Wilson5
6086 1 Andrew Saxon
6086 2 Andrew Saxon
6086 3 Ian Thompson
6086 4 Ian Thompson
6086 5 Phil Dargan

what i want is after a manager ends i want a null to be inserted for
each of there columns
so that i can distinguish that when a new manager starts

so thatt output looks like this

manager personlevel person name
2085 1 Howard Wilson1
2085 2 Howard Wilson2
2085 3 Howard Wilson3
2085 4 Howard Wilson4
2085 5 Howard Wilson5
null null null
6086 1 Andrew Saxon
6086 2 Andrew Saxon
6086 3 Ian Thompson
6086 4 Ian Thompson
6086 5 Phil Dargan

Brlliant minds any solution for this..
i know can i loop through the records and do it
and check for a new manager
but i want a better solution ..
give me your ideads folks..

Regards,
Navin Mahindroo