On Mon, Nov 22, 2004 at 05:47:19 -0800, Stephan Szabo wrote: >No, but I think you're supposed to use FM in such cases. > >select to_number(1000, 'FM999,999');
Indeed, it works with 'FM'. Thanks! David -- David Schweikert | phone: +41 44 632 7019 System manager ISG.EE | walk: ETH Zentrum, ETL F24.1 ETH Zurich, Switzerland | web: http://people.ee.ethz.ch/dws ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]