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. > ================================================ > > >
