>Didi You send udates from that view?
No
>
>BTW
>
>PADR(NVL(Sdata.sertype,"NON-SERIALIZED"),13," ")
>
>You should change 13 to 14 here "NON-SERIALIZED" contains 14 chars
Good catch. The Sertype is only 1 character. No change in query.
Duty is ours, the results are God's - John Quincy Adams