Create a column and insert data to that column

Hi

I have a table assume Users and i need to add a column and insert a default value.
the default value is in the same table(Users)
assume Users table has ID, Name, Password
Now i need to insert a column as Confirm Password which should be same as Password value.
How can i alter the table.
Can anyone help me
Thanks,
Harish Reddy
...