Yup! it worked! thanks buddy. Actually, its not a sufficient info, my info are just enough thats why you(Roelof) created the solution. For me, if it is insufficient, you will be askin for...

,  I have another case again where I need to use EXECUTE TO UPDATE certain table, and also to INSERT...

DECLARE @tbl nvarchar(125), @lookupvalue nvarchar(125),...

JESPER, YOUR LAST CODE WORKED!!! . GILA MONSTER THANKS SO MUCH. WHERE ARE YOU GUYS FROM(COUNTRY)? JUST ASKIN.

i tried jesper's code, but still the result is null.

I want to get the value of @lvido from 'SELECT @lvido=lvid FROM ' + @tbl + ' WHERE lvid=' +...