It would be: SELECT (CASE Number WHEN 1 THEN 'First' ELSE 'Other' END) AS Description
FROMTable
-DEJ
> -----Original Message-----
> Hi!
>
> I'm new in the list (and in PostgreSQL too). I'd like to know
> if it's posible to perform a function like SQL Server's "iif"
> in a SELECT query. Some like:
>
> SELECT iif (Number=1, "First", "Other") AS Description
> FROM Table;
>
> I don't know if I've explained properly...
> --
> Eduardo Noeda -- Virtual Software
> enoeda@virtualsw.es