>Thank you Sergey - it works. Have you any idea how to PAD() a field length in a SELECT statement? As in select a,b,c,PAD(d,25). Adding the PAD() there gives an error - is there any way of adding to the length of d in the cursor the data is put into?
>
PAD() should work
--sb--