Hi everybody!

is it possible to use macro substitutions in SQL 7 in order to update a column, let me explain a little bit more:

I have a table with next columns:
Cell,year, W1, W2, W3, W4, W5, ... W52 (W = Week)

And I need to update this columns with a single 'Update' statement but I can't figure out how can achieve this. In foxpro is very ease: using the macro (&) but the most similar function is COL_NAME but it can't be used in this statement.

Any Idea

Best Regards

Martin Alcaraz