Sorry, I know that this question is not related to DNN directly, but I'm trying to add it to my DNN SQL DB.  I'm trying to make my table name as a variable.  The Function below is wrong because I'm using the @Table_Name in my Select Statement.  If I use the Exec (@SqlStmt) command, I can not return the result found.  Any idea on how I can re-write this function?  

Create Function Test(@Table_Name)

RETURNS int

          Declare @Returned_val as int

         Select @Returned_Val = A.Code

         from @Table_Name A

          where A.ID = 5

        Return @Returned_val

Thank you, I will do.  But, is it different than the "Exec" command?

Thanks much.  This really helped.