var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I need a tool to break up my data. Help please
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!
Originally Posted by r937