You can build SQL Update statement as a string and than execute it using EXECUTE() command or sp_executesql system SP. See SQL BOL for details.

>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