Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Dynamic field referencing?

Author  Topic  jhilb Starting Member 22 Posts Posted - 2001-06-18 : 07:05:08 I don't think there is a way to do this but I have a need so here is a shot... Is their a way to 'dynamically' reference a field in T-SQL? Something like this... set @MyColumn = 'Amount1' update MasterTable set @MyColumn = @MyColumn + 1 know what I mean? Thanks