User defined Functions in sqlserver

See more:

SQL

server

create function get_code()
 returns char(10)
  as begin declare @lastval char(5)
   set @lastval = (select max(advisor_code) from tbl_advisor_table)
    if @lastval is null set @lastval = 'DFP'
     declare @i int set @i = right(@lastval,4) + 1
     return 'C' + right('000' + convert(varchar(10),@i),4)

      end

this is my fuction

alter table tbl_advisor_table add advisor_code uniqueidentifier default get_code()

its says

'get_code' is not a recognized built-in function name.

im keep trying..