How to use a User-Defined Function in Place of a Table in SQL server

In Microsoft SQL Server 2000 or higher, developers can create a user-defined function that returns a table. Such functions are useful for performing complex or procedural logic. Developers can write a query that uses the fn_GetSomeData function as a source of data. The resulting SQL might look like this:

SELECT *

FROM

fn_GetSomeData (‘JKL12345YH’)