Re: hardcoded columns

of course this would be avoided with a different table design.

The month should be a column in the data then it could be matched in the where clause without dynamic sql...

shrug.
randy

"Nick G. Anagnos" wrote:

> I have a table with different date columns, ex: c2000_02, c2000_03, ...
> I have a program that has the columns hardcoded depending on which
> column to update, ex: update table set c2000_02 = "xoxoxo"
> Instead of hardcoding the column in the update statement, I'd like to
> have the c2000_02 as a variable so the statement would look like:
> update table set variable = "xoxoxo"
>
> Nick
Received on Mon May 15 2000 - 00:00:00 CDT