Subject Re: [firebird-support] ansi sql92 and Firebird sql
Author Martijn Tonies
Hello,

> Firebird1.5 is supposed to be compliant with SQL92, isn't it? If it

Try wise-cracking someone else ;-)

SQL-compliance comes in "levels". "Entry", "intermediate" and "full",
I believe. You don't need the below to be entry-level compliant.

> does:
> 1. How can we explain that Firebird does not support the 'TRIM'
> function, ie TRIM([ [ LEADING | TRAILING | BOTH ] [character] FROM ]
> expr)?
> 2. For getting this function, is the only workaround the use of UDF
> (user defined functions)?

Yes.

> 3. When will Firebird support the TRIM function, if it's not already
> in a latest release?

I'm unsure.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com