it is also working, thanks !
________________________________ From: Christian Mereles <chmere...@gmail.com> To: firebird-support@yahoogroups.com Sent: Wednesday, January 23, 2013 3:02 PM Subject: [firebird-support] Re: IIF bug? and... SELECT '11'||IIF(1>2,'00000000000000', cast('' as varchar(1)))||'.22' FROM rdb$database Regards. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]