I have the following table:
Table A
FNAME | LNAME
james | Bond
John | Brit
raje | van
I want to insert first letter from first column with full last name to create a new username column for the table:
Table A
USERNAME
jbond
jbrit
rvan
If this is not possible, I at least need to update the lastname from lname to newly created username column and to set a default password for all the rows