• Oh yes. There is a limitation in SQL Server. We can't use Exec inside UDF.

    EXEC('Select' + @strStatement) can't be used inside your function. 🙁

    But the solutions remains intact. You can use EXEC('Select' + @strStatement) to evaluate an expression in your queries.