Invalid Column Name Sql-Error :Executing a stored procedure

[AmjiBhai]

I am executing a stored procedure .... the following command need to be rectified.

set @str = "Update [dbo].[Lists] SET ASREFSER='"+@server+"' where isnull(ASREFSER,'')=''"

exec ( @str )

Error Message as shown by SQL Server 2012 is as follows
Invalid column name 'Update [dbo].[Lists] SET ASREFSER=''.


I confirmed that the column name is correctly spelled.

Please help

 

[Abraham Andres Luna]

So is your @server variable filled with a value? Or is it NULL?