Subject | Re: [firebird-support] IIF bug? |
---|---|
Author | Mark Rotteveel |
Post date | 2013-01-23T13:28:27Z |
On Wed, 23 Jan 2013 14:24:18 +0100, "Djordje Radovanovic"
<softsistem@...> wrote:
(as the return type of ltrim is VARCHAR).
Mark
<softsistem@...> wrote:
> SELECT '11'||(IIF(1>2,'00000000000000',ltrim('')))||'.22' FROMThis works because this coerces the resulttype of IIF to be VARCHAR(14)
> rdb$database
>
> ltrim is what you need then result is 11.22
(as the return type of ltrim is VARCHAR).
Mark