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.
