thanks!


________________________________
From: Mark Rotteveel <mark@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, January 23, 2013 4:31 PM
Subject: Re: [firebird-support] IIF bug?


 
On Wed, 23 Jan 2013 05:45:40 -0800 (PST), "Mr. John" mr_johnmr@...>
wrote:

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

ltrim is not a built-in function, it is an udf:
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-udf-ltrim.html

You could just simply use the built-in function trim:
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-trim.html

If you want to use left trim (which is not needed in your original
question), then you can use TRIM(LEADING FROM )

Mark



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