Razzak & Albert, I said in my email I was fading. My brain said leading spaces and I typed leading zeros and then when I read it before sending I read spaces.
Thanks for the SQL command Razzak, that's what I was looking for. Paul -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: June 19, 2017 4:04 PM To: [email protected] Subject: Re: [RBASE-L] - Update & LTRIM 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.
