> 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?

Oracle isn't right on a whole lot of occasions when it comes to the
SQL standard.

That being said, it has improved over the last few years :-)

With regards,

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