> lpad and rpad never truncate, they only pad.> > Perhaps they *should* truncate if the specified length is less than> the original string length. Does Oracle do that?
Yes, it truncates, same as Informix.
Andreas