SELECT '11'||(IIF(1>2,'00000000000000',ltrim('')))||'.22' FROM rdb$database

ltrim is what you need then result is 11.22

Best regards,

Djordje Radovanovic


From: Mr. John
Sent: Wednesday, January 23, 2013 1:49 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] IIF bug?


Hi !
I'm using FB 2.5.2 on XP
I've discovered a strange behavior for IIF function:

SELECT '11'||(IIF(1>2,'00000000000000',''))||'.22' FROM rdb$database

as it can see condition is always false,IIF should result an empty string but the result is not
11.22
,the result is 11 .22
why?

Thanks!

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]