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 <field>)

Mark