On Mon, Feb 25, 2008 at 7:59 PM, Robert Freeman <robertgfreeman@xxxxxxxxx> wrote: > I have not tested the format clause with a substitution (and I'm not > around an 11g database just now) but I think it should work. > I am, and it did work. Thanks Robert. > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info >