URGENT (srry) ->ADODB update many

hi there,

i have a little question..
I have a database with groups..
some contacts are in groups..
now i want.. for example to change..
all the contacts that have group name "group2"
change to group name "group5"

How can this be done?
thnx

In sql terms you can do the following

Code:

---

update <table> set <field> = 'group5' where <field> = 'group2'

---

Thnx that's what i needed!!!!!!

Thnx for the quick repley too!

I could almost hug you for this :p :p :p