Paul - if you format the column to currency or other numeric status, the leading zeroes will disappear. The data seems to have been imported as a text value if the leading zeroes show up
Albert > On Jun 19, 2017, at 2:03 PM, A. Razzak Memon <[email protected]> wrote: > > Paul, > > FWIW ... > > LTRIM is NOT going to clean up leading zeros. > > If you need to TRIM leading an/or trailing "spaces", you may use the UPDATE > command as follows: > > UPDATE tablename SET columnname1 = (TRIM(columnname1)), columnname2 = > (TRIM(columnname2)), columnname3 = (TRIM(columnname3)) > > Hope that helps! > > Very Best R:egards, > > Razzak > > At 03:53 PM 6/19/2017, Paul C. Buckley wrote: > >> Good afternoon, >> >> It must be Monday, I’m fading already and it’s only 4:00. I’m using >> the latest version of R:BASE X Enterprise. I’d capturing some data from a >> SQL table into an R:BASE table and I’d like to “clean it up†some >> before I work on it. I know several of the columns have leading zeros. I >> know I can create a Declare loop and go thru each table and do an LTRIM on >> each column. I’m wondering if there is a slick SQL Update command that >> would allow me to clean up the whole table, even if I had to run it >> separately for each column? >> >> Thanks in advance, >> Paul Buckley >> >> -- >> You received this message because you are subscribed to the Google Groups >> "RBASE-L" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to >> <mailto:[email protected]>[email protected]. >> For more options, visit >> <https://groups.google.com/d/optout>https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
