At 11:56 AM 20/10/2005 +0000, you wrote:

>I'm using Firebird-1.5.2.4731, and client IBExpert.
>According to http://www.destructor.de/firebird/1.5/case.txt, i have
>implemented following case query(here part of the query),
>But same error msg is giving and not executing.
>
>case
> when MP.RoleID = -1 then 'All Users'
> when MP.RoleID = -2 then 'Superuser'
> when MP.RoleID = -3 then 'Unauthenticated Users'
> else R.RoleName
>end
>
>I can't see any problem, but why not executing, any comment???

Refer to Example B at your URL and try this instead:

case
when (MP.RoleID = -1) then 'All Users'
when (MP.RoleID = -2) then 'Superuser'
when (MP.RoleID = -3) then 'Unauthenticated Users'
else R(.RoleName
end

./heLen