decrement int by 1 using SQL server 2000 [Archive]

Click to See Complete Forum and Search --> : decrement int by 1 using SQL server 2000

mattastic

12-19-2006, 09:39 AM

Hi,

Can anyone tell me the sql syntax for this within the query?

Thankyou

scottrickman

12-19-2006, 10:19 AM

Update [tablename] SET [intField] = [intField] - 1
Might do it?