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" <[email protected]> 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
