how to add 1 to the field

when i work with Aceess Db i have SQL statment that cout the visitor:

update Tbl1 set fldvisit = fldvisit +1 where fld2='abc'

when i move to SQL Server it's not working
what to do?Hi

This should be ok! What is the error/problem?

Posting DDL and example data http://www.aspfaq.com/etiquett*e.asp?id=5006
will help others to re-create the problem.

John

"yuval" <yuvalbra@.gmail.com> wrote in message
news:1115492012.471848.288840@.g14g2000cwa.googlegr oups.com...
> when i work with Aceess Db i have SQL statment that cout the visitor:
>
> update Tbl1 set fldvisit = fldvisit +1 where fld2='abc'
>
>
> when i move to SQL Server it's not working
> what to do?|||What does "not working" mean. Tell us the error message if any or post some
example code to reproduce the problem (CREATE, INSERT, UPDATE statements).

--
David Portas
SQL Server MVP
--