Hi,=0D=0A=0D=0AYou can have only one where clause in your statement. If you
 want to check with multiple conditions, you can use "OR" or "AND" operator
 or both to check with multiple conditions in your statement.=0D=0A=0D=0AFo
r e.g.=0D=0Aupdate table_name set column_name=3DValue, ....  where Column_n
ame=3Dcoditon OR column_name=3Dcondition=0D=0A=0D=0ARegards=0D=0Asantosh Ka
le.=0D=0A=0D=0A=0D=0A=0D=0AOn Wed, 17 Oct 2001 William Markham wrote :=0D
=0A> Is it possible to have one where clause after another?  =0D=0A> I have
 about 11 =0D=0A> seperate long lists of conditions that as long as one =0D
=0A> of them is true, it =0D=0A> updates a file.  Right now it is in a 7 pa
ge (small =0D=0A> font) query file that =0D=0A> has all 11 condition lists 
in seperate select =0D=0A> statements.  I am trying to =0D=0A> reduce it.  
Any ideas?=0D=0A> =0D=0A> Thanks=0D=0A> William Markham=0D=0A> =0D=0A> =0D
=0A> ---=0D=0A> You are currently subscribed to sql_language as: =0D=0A> sa
ntoshdkale@r...=0D=0A> To unsubscribe send a blank email to =0D
=0A> $subst('Email.Unsub')=0D=0A> =0D=0A =0A