Create User defined Function SQL

I have a function created. It needs to be adjusted so that it can be created as a default in create table script to populate values from another table