Thanks guys for the tips. I will give them both a try. Dan
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Friday, July 24, 2009 11:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: canadian zipcodes In addition to Bill's advice, you might find the formula as follows slightly faster: UPDATE tmpimport SET zipcode = ((SGET(zipcode,3,1))* + ' ' + *(SGET(zipcode, + 3,4))) WHERE zipcode IS NOT NULL UPDATE tmpimport SET zipcode = ((SGET(zipcode,3,1)) *&* (SGET(zipcode, + 3,4))) WHERE zipcode IS NOT NULL The ampersand inserts a space. Albert Bill Downall wrote: > Dan, > > drop the index on the column, then do your update, then create the index again. > > On Friday, July 24, 2009, Dan Goldberg <[email protected]> wrote: > >> We import canadian zipcodes from time to time but we get them like: >> >> A0A1A0 >> >> But they want them with a space like: >> >> A0A 1A0 >> >> I tried the update command: >> >> UPDATE tmpimport SET zipcode = ((SGET(zipcode,3,1)) + ' ' + (SGET(zipcode, + >> 3,4))) WHERE zipcode IS NOT NULL >> >> It works but takes a long time to run. The canadian zipcodes are over >> 820000 rows. >> >> Does anybody know of a command that might run quicker?? >> >> TIA >> >> Dan Goldberg >> >> --- RBASE-L >> ================================================ >> TO POST A MESSAGE TO ALL MEMBERS: >> Send a plain text email to [email protected] >> >> (Don't use any of these words as your Subject: >> INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, >> DIGEST, RESEND, HELP) >> ================================================ >> TO SEE MESSAGE POSTING GUIDELINES: >> Send a plain text email to [email protected] In the message SUBJECT, >> put just one word: INTRO >> ================================================ >> TO UNSUBSCRIBE: >> Send a plain text email to [email protected] In the message SUBJECT, >> put just one word: UNSUBSCRIBE >> ================================================ >> TO SEARCH ARCHIVES: >> Send a plain text email to [email protected] In the message SUBJECT, >> put just one word: SEARCH-n (where n is the number of days). In the >> message body, place any text to search for. >> ================================================ >> >> >> >> > > > >
