Thanks to all who replied. I used the first reply from Tim Nuteson and it worked fine:
OldString = "RA00-12-002" update Table set Oldstring = Left$(OldString, 4) + Right$(OldString, 4) I'm checking the other replies as well. Thanks again! Renee Gerasimtchouk --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2986
