>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?
>
>Thanks!
There is no PAD function, there are PADC/PADR/PADL.
If it's not broken, fix it until it is.
My Blog