[SQL] Function output into record

[CJPowell27]

Hey guys I am trying to have automatically fill the a column with output from another function. So basically my table has a first name and a last name column and I am trying to fill an initials column with the first letter from each of the other two columns. So for example the following:

first_name | last_name | initials

John          | Smith         |

 

would populate the initials column with JS. I can't think of a keyword that I have learned yet that allows me to update existing columns with output from any function that would give me the initials like concat(substring(first_name,1,1),substring(last_name,1,1);

[CJPowell27]

MODS go ahead and delete this I did some random stuff and it worked!

update tableName set initials=(select concat(substring(first_name,1,1),substring(last_name,1,1))); it's ugly but it works