Subject Re: [firebird-support] IIF bug?
Author Mark Rotteveel
On Wed, 23 Jan 2013 14:24:18 +0100, "Djordje Radovanovic"
<softsistem@...> wrote:
> SELECT '11'||(IIF(1>2,'00000000000000',ltrim('')))||'.22' FROM
> rdb$database
>
> ltrim is what you need then result is 11.22

This works because this coerces the resulttype of IIF to be VARCHAR(14)
(as the return type of ltrim is VARCHAR).

Mark