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