Inline Functions(Table valued function)

alter function ufn_crmlead(@lead_source varchar(100))
returns table as
return(select crmlead_id,lead_source,city,state,country,isnull(address1,'') +''+isnull(address2,'') as address
from crmlead
where lead_source=@lead_source)
go
select * from ufn_crmlead('Purchased List')