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.