XPost: comp.databases.oracle.misc, microsoft.public.sqlserver.programming   
   From: george.dainis@bluecorner.com   
      
   As well known a DATE or TIMESTAMP type can be converted (to VARCAHR) after   
   selection but BEFORE   
   writing to the ResultSet by using the CONVERT function e.g.   
      
   SELECT  CONVERT(char(10), MYTIMESTAMP, 101)) FROM ... WHERE ....   
      
   Is there something similar if the original field is a DECIMAL/NUMERIC field?   
      
   E.g.   
      
   SELECT DEC_CONVERT(char(30), MYDECIMAL, '###########0.00') FROM ..... WHERE   
   ....   
      
   George   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)