Pseudocode:
declare @var datatype;
select @var = function(@param) -- for scalar
select @var = col from schema.function(@param) -- for table valued
For table valued functions, note that @var will contain the first value returned in the result set from the function.
Ole Kristian Velstadbråten Bangås -
Virinco -
Facebook -
TwitterConcatenating Row Values in Transact-SQL[/url]