there is any left trimming function ?
I got error :
Function unknown.
LTRIM.

thanks.


________________________________
From: Djordje Radovanovic <softsistem@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, January 23, 2013 3:24 PM
Subject: Re: [firebird-support] IIF bug?


 
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]




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