Hi,
If I have a table with empID, firstname, lastname and I have 300 employees on this table. Is there a way I can add a new column called "email" and automatically populate in each employee's email as left(firstname, 1) + lastname + 'test.com'
example: james landon ----> jlandon@test.com
If I have a table with empID, firstname, lastname and I have 300 employees on this table. Is there a way I can add a new column called "email" and automatically populate in each employee's email as left(firstname, 1) + lastname + 'test.com'
example: james landon ----> jlandon@test.com