sql = "UPDATE table SET column = (column + " & aspVariable & ") WHERE
....?..."
conn.execute(sql)


--
Aaron Bertrand, SQL Server MVP
[url]http://www.aspfaq.com/[/url]

Please reply in the newsgroups, but if you absolutely
must reply via e-mail, please take out the TRASH.


"Jacob" <yak2016@comcast.net> wrote in message
news:#bhLsnRQDHA.2476@TK2MSFTNGP10.phx.gbl...
> I'm using SQL Server 7 and this is what I want. I need to read a field
from
> a table, and a number from some just-posted form data from the user, then
> write the new number right back to the same field. Of course, I could
just
> do a select, add to the value in a variable, then do an update with the
new
> value, but I was just wondering if there was a quicker way to go about it.
>
> Thanks,
> Jacob
>
>