Hi mahdoom_a, I've just created this table MNGRNT (like yours)

RFRNC AQNO
50001
50002
50003

I then ran this code:
update mngrnt
set rfrnc=
case
when aqno = 50001 then '155'
when aqno = 50002 then '166'
when aqno = 50003 then '1331'
end

This is the message - successful update
Plan
PLAN (MNGRNT NATURAL)

3 record(s) was(were) updated in MNGRNT

This is the table after update
RFRNC AQNO
155 50001
166 50002
1331 50003

You must be doing something that you're not telling us because this
"just works" and is as simple as it gets really.

What else are you trying to do?
Regards
Alan

Alan J Davies
Aldis

On 02/07/2012 16:23, mahdoom_a wrote:
> aqno is intger
> rfrnc is varchar
>
> I tried another format of case statement
> like:
>
> update mngrnt set rfrnc = case aqno
> when 50001 then '155'
> when 50002 then '166'
>
> end
>
> I got same SQL error but unknown token is aqno
>
> Regards.
>
> --- In firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>, Alan J Davies
> <Alan.Davies@...> wrote:
> >
> > What is aqno? An integer or character field?
> > If its an integer try without ' '
> > Is it in the same table as rfrnc?
> > Otherwise there is nothing wrong with the code.
> > Alan
> >
> > Alan J Davies
> > Aldis
> >
> >
> >
> > On 02/07/2012 07:40, mahdoom_a wrote:
> > > Great Alan,
> > >
> > > I tried this
> > >
> > > update mngrnt
> > > set rfrnc=
> > > case
> > > when aqno = '50001' then 155
> > > when aqno = '50002' then 166
> > > when aqno = '50003' then 1331
> > > end
> > >
> > > I got SQL error
> > >
> > > Invalid token.
> > > Dynamic SQL Error.
> > > SQL error code = -104.
> > > Token unknown - line 4, char 1.
> > > when.
> > >
> > > 'when' is identified(in bold black)but I don't know why its invalid.
> > >
> > > Best Regards
> > >
> > > Ahmad Sarhan
> > >
> > >
> > > --- In firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> > > <mailto:firebird-support%40yahoogroups.com>, Alan J Davies
> > > <Alan.Davies@> wrote:
> > > >
> > > > 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
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>
>