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?
>I'm sorry but I don't understand what you're trying to do.