Newbie Dynamic Code Question

[whateveragain]

The compiler doesn't like the ' * ' as a multiplication sign. How can I write the following statement in dynamic code?

exec('update ' + @tablename + ' set wkcol = (' + @nweight + ' * ' + @columnname + ') where rootkey = ' + @mmkey)

 

[bborissov]

All variables must be n/varchar or should be CAST to it. Are you sure @nweight is n/varchar?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.