title: Receiving error "Select statements included within a function cannot return data to a client"
body: <p>Receiving an error when attempting to use a Select statement in a function. The error states:</p>
  
  <blockquote>
    <p>Msg 444, Level 16, State 2, Procedure JDE_GetWhereClause_test, Line 26<br>
    Select statements included within a function cannot return data to a client.</p>
  </blockquote>
  
  <p>Any ideas?</p>
  
  <pre><code>CREATE FUNCTION [dbo].[JDE_GetWhereClause_test]
  (
  @tablename as varchar
  )
  RETURNS varchar(max)
  AS
  BEGIN
  -- Declare the return variable here
  Declare @ResultVar as varchar(max)
  
  -- Add the T-SQL statements to compute the return value here
  
  set @tablename = 'F0101'
  Declare @Sql nvarchar(max)
  Declare my_cur cursor for
      SELECT fsuser FROM dbo.JDE_ExRowSecurity where fsuser = fsuser;
  
  Declare @fsuser as nchar(15)
  open my_cur;
  fetch next from my_cur;
  while @@fetch_status = 0
     begin
        fetch next from my_cur into @fsuser;    
        set @ResultVar += ',' + @fsuser;
     end;
  close my_cur;
  deallocate my_cur;
  
  -- Return the result of the function
  RETURN @ResultVar
  END
  </code></pre>