9df7c0b7   
   From: news@invalid.invalid   
      
   > Thanks I changed it to decimal(18,1) and that seemed to work.  What do   
   > you mean by this...   
   >   
   > When you the decimal data type, you should always specify precision   
   > and   
   > scale explicitly, and not rely on defaults.   
      
   You already do this with (18,1)!   
   I think he did not read this in your first post because of   
      
    >> * 100) AS decimal   
    >> (6,   
    >> 1)) AS perc   
      
   Lutz   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)