Might be one of Rachel's stories in Novemebr, Niall. Carel-Jan On Thu, 2004-08-19 at 22:25, Niall Litchfield wrote: > true story 2 - this one is me though. > > take one script > > > select RPAD(col,255,' ') colname > from tab > where (some marginally imaginative logic) > > wrap in > > set trimspool on > spool filename > > > ponder for 36 hours why RPAD wasn't working :) ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------