update T1
set Col1 =
case
when Col2 = No1
then Val1
when Col2 = No2
then Val2
when Col2 = No3
then Val3
end


Alan J Davies
Aldis

On 01/07/2012 17:53, Hans wrote:
> Using the SQL CASE in your update statement may work.
>
> Best Regards
> Hans
>
> Sent from my iWatuski
>
> On 2012-07-01, at 9:17 AM, "Ahmad F. Sarhan" <mahdoom_a@...
> <mailto:mahdoom_a%40yahoo.com>> wrote:
>
> Hey everyone,
> I need your help in one of 2 questions please,
>
> 1st.
>
> i need to update my table with multi values , each value has its own
> condition
> I mean
> update T1
> set Col1 = Val1 where Col2 = No1
> set Col1 = Val2 where Col2 = No2
> set Col1 = Val3 where Col2 = No3
> .
> .
> .
> Set Col1 = Val 600 where Col2 = No600
>
> and so on. I tried the simple lines as I wrote above but its not working.
>
> 2nd.
>
> I want to update my Table from excel sheet how can firebird read from
> excel sheet.
>
> Thanks
>
> ~{ Ahmad F. Sarhan }~
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>