Thanks. It worked.

I had to use CAST for the Where clause.

DECLARE @ID int

SET @ID = 1

SET @where = ' WHERE ID = '+ cast(@ID as varchar(8))

Thanks for help.

It is working if you do not have a WHERE clause.

If you try to use a WHERE clause using a variable will not work.

The same if...