tsql - Return multiple values from a SQL Server function

Question

How would I return multiple values (say, a number and a string) from a user-defined function in SQL Server?

Answer 1

Change it to a table-valued function

Please refer to the following link, for example.