... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.oracle

Overblown overpriced overengineered SHIT

2,288 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 623 of 2,288

Ken Denny to kumu

Re: Removing Leading Zeros Using SQL

31 Oct 03 17:17:17

   From: ken@kendenny.com   
      
   forlist2001@yahoo.com (kumu) wrote in news:a44abd39.0310310826.2a8a73a5   
   @posting.google.com:   
      
   > Hi, Is there a way to write an update statement to remove leading   
   > zeros from a column? The column is a varchar field and the number of   
   > zeros vary.   
   > Thanks in Advance   
      
   UPDATE table   
   SET column=LTRIM(column,'0');   
      
   --   
   Ken Denny   
   http://www.kendenny.com/   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]