the simple solution would be to let the database do it for you. Double check my start and finish arguments that they select the correct positions.
select substring(number,1,2)+' '+substring(number,3,5)+' '+substring(number,6,len(number)) as formattedNumber Otherwise to reuse the functionality you might want to do the work in a bean or custom tag. -----Original Message----- From: Shabbir Jadliwala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 11:54 AM To: [EMAIL PROTECTED] Subject: Formatting numbers. Hello everyone, This is my first mail to this mail group. I would like to ask for help from you people relating to formatting numbers. I have got the numbers form Database as 12345678.90. I would like to change it to look like 12 345 678.90. Thank you very much for your help. Shabbir Jadliwala ---------- Web Programmer ---------------------------------------------------------------------------- --------------- S C H E M A N T I X * Tomorrow's Solutions Today http://www.schemantix.com * Tel. +420 606 327 467 ---------------------------------------------------------------------------- --------------- =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
