Dan Have you tried using the SPUT function instead of the SGET UPDATE ... SET ZIPCODE = (SPUT(zipcode,' ',4)) .....
Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, November 04, 2009 9:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - space in zipcode I have data that I receive from a vendor for canadian zipcodes and need to put a space after the first three characters. V0R1R1 Need to be V0R 1R1 So I run the command: UPDATE tmpdealerlocator SET zipcode = + ((SGET(zipcode,3,1)) + ' ' + (SGET(zipcode,3,4))) + WHERE zipcode IS NOT NULL It runs buts takes forever to put the spaces in it. Does anyone have a suggestion to make it run faster?? TIA Dan Goldberg
