I have to ask, why?
>When I try the following test, I get error (below the expression)
>
>Declare MyVar decimal (12,2)
>Select Field1, @MyVar = num_field from MyTable
>
>
>that "A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations."
>
>Is there a way to still retrieve data and set a value to a variable?
>
>TIA
--sb--