Hello everyone, I have a record set with about 2000+ records that I need to insert into a db. One of the columns contains area codes WITH phone numbers formatted as such:
I have to break out the first 4 characters which would be the area code and the hyphen and move only the first 3 into another column. The hyphen will just get discarded.

Is there a tool or some concept that someone can point me to so that I can complete this? I don't want to do this by hand. Thanks for the help. Frank

i would use the SUBSTRING function in a query

Rudy, your the best! Thanks!