> 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
- Re: [GENERAL] Oracle-compatible lpad/rpad behavior Zeugswetter Andreas SB
- Re: [GENERAL] Oracle-compatible lpad/rpad beha... Andrew Nosenko
- Re: [GENERAL] Oracle-compatible lpad/rpad ... Jonathan Ellis