how to write this query

[hno]

 

 

HI

I want a query that add 1 to the value that the query has been retrieve from the database.In the other hands a=a+1 and then update that field.

thanks

[Maq]

 

 

HI

I want a query that add 1 to the value that the query has been retrieve from the database.In the other hands a=a+1 and then update that field.

thanks

 

I'm having difficulty understanding you.  Do you want to add 1 to a field?

 

UPDATE table SET field = field + 1

 

Or, do you want to add one to field 'a' and assign it to field 'b'?