Hi,

> The form that I'm using in Delphi can you see here:
>
> http://www.famstuij.dyndns.org:1026/images/zoeken.jpg
>
> The left edit box is the place where the user can write the text
> where he is looking for.
>
> The right combobox is the place where the user tells the system where
> it must search.
>
> Normally in SQL you can do the next thing:
>
> SELECT ARTIKELID, CASE MULTIPACK WHEN 'Y' THEN 'YES' ELSE 'NO' END
> FROM ....
>
> So my only question is how could I do this in Interbase?

Using UDF or Stored Procedure, but maybe better on the client site. If you
use delphi you could use the "TField.OnGetText" event !
btw: Firebird 1.5 (which is currently in beta) will have this CASE function.

> I know there are some other possibilities, for example showing
> radiobuttons. But that is something what I do NOT want.

I would do it also on the client site.

Regards,
Arno Brinkman