>declare fieldlist cursor for > select table_name, column_name, data_type > from information_schema.columns > where DAta_Type = 'datetime' > >declare @table AS CHAR(15), @Column AS CHAR(20) <b>DECLARE @SqlUpdate varchar(1000)</b> >SET NOCOUNT ON > >OPEN fieldlist > >FETCH NEXT FROM FieldList > INTO @table, @Column > >WHILE (@@FETCH_STATUS = 0) > BEGIN <b>@SqlUpdate = 'UPDATE ' + @table + ' SET ' + @Column + ' = Dateadd(Month,3,' + @column + ')' EXECUTE sp_executesql @SqlUpdate </b> <b>--</b> UPDATE @table SET @Column = Dateadd(Month,3,@Column) > FETCH NEXT FROM FieldList INTO @Table, @Column > END >>Notice the update command would simply use the results from @table and @column to update the proper fields. In VFP I could use a Macro substitution using the @table and @Column variables, however I'm not sure how to do that in SQL. Any ideas?