Scalar Function sample

create function dbo.f_ContactFullName(@id as int)
        returns varchar(101)
asbegin  declare @FullName varchar(101);

  select @FullName = FirstName + ‘ ‘ + LastName
    from Person.Contact
  where ContactID = @id;

  return @FullName;

end;

--------------------------------------------------------------

select dbo.f_ContactFullName(1);
————————-Gustavo Achong(1 row(s) affected)