--- In firebird-support@yahoogroups.com, "DataCom - Diego"
<diego@d...> wrote:

> Hi all,
>
> I noticed that Firebird and InterBase ignore trailing spaces when

comparing

> two Strings. In a Borland site, I found the following: "SQL requires

that

> trailing spaces be ignored when comparing two strings of different

lengths".

> And now I discovered that Oracle doesnt ignore them. Wich one is right?

In the sense of the SQL standard FB is almost always right when
compared with any other SQL server (not sure about Postgress) ;) If
you need trailing spaces when comparing, in FB you can follow standard
recommendations and use LIKE, if not - direct compare.

Best regards,
Alexander