>Yet another newbie question on stored procedure.
>
>I am trying to learn to get the OUTPUT parameter value.
>
>Here is simple stored proc:
>

>MyProc
>   @Test char(5) = '' OUTPUT
>BEGIN
>   set @Test = 'ABCD'
>   RETURN
>END
>

>
>In a query window I do the following:
>

>declare @Test char(5)
>set @Test = ''
>execute MyProc @Test
>print @Test
>

>
>Why do I see empty value in @Test at the bottom?
>
>TIA.

declare @TestReturn char(5)
EXEC @TestReturn = myproc
Print @TestReturn