>I'm sorry, let me try it this way.
>
>To save the return value in @SourceDescr, from a UDF, we can use the following syntax:
>

>Set @SourceDesc = ( select dbo.Ims_fn_GetSourceDesc(1) )
>

>What is the correct syntax if this UDF was a procedure and return a single row and single field?

The only way is to use a temporary table as I showed previously.