Update multiple records at once.

Hello

I was wondering how you would do a update for records.

update state set region_no = 1
where state_cd = 'VT', 'RI';

What I tried to do here is set both of these two records to have a region number of one but it does not run?

Thanks for the help Liam

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Mar 11 2000 - 00:00:00 CST