title: Returning multiple values from a function in sql server
body: <p>I researched and tried but cant figure it out this is what i got so far.
  What i want it to do is concatenate Fstring and Lstring and return the result plus the current date in this case @date
  i declared the variables @Fstring and @Lstring as input and @date as the getdate function.
  I can only get it to either return the date or @fullname :(
  and i cant figure out where im wrong
  any help in the right direction will be appreciated</p>
  
  <pre><code>==== start function===
  create function ufn_function_4
  (
          @Fstring varchar(20) , @Lstring varchar(20)
  )
  returns varchar (20)
  as
  begin
  Declare @date datetime = getdate()
  Declare @fullname varchar(100)
  set @fullname = @Fstring + ' ' + @Lstring;
  return (@date+@fullname)
  end
  go
  
  ==== start select ====
  
  select [dbo].[ufn_function_4]('Fred','Van Vliet');
  </code></pre>