Re: Update multiple records at once.

From: Pradhan <empradhan_at_dplus.net>
Date: 2000/03/11
Message-ID: <38CA8C10.E47B0FB@dplus.net>#1/1

hi
update state set region_no = 1
where state_cd in ('VT', 'RI');

will do the job...

hth
pradhan

liam_2e_at_my-deja.com wrote:

> 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