Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL question
- Thread starter savok
- Start date
ALTER TABLE tablename ADD COLUMN SSN2 Text(50)
INSERT INTO tablename ( SSN2 )
SELECT tablename.SSN
FROM tablename;
I'm not sure what kind of database you are working with but this sql statement should do that for you unless you're working with an Access table.
INSERT INTO tablename ( SSN2 )
SELECT tablename.SSN
FROM tablename;
I'm not sure what kind of database you are working with but this sql statement should do that for you unless you're working with an Access table.
- Status
Similar threads
