> For what little it's worth, the SQL standard specifies that trailing
> blanks are to be ignored when comparing strings for equality, but that
> they are significant when the comparision uses the LIKE operator.
>
> Why, I do not know. But it does. And InterBase and Firebird have
> followed that rule since the beginning of standard SQL.

A great :-)

Then it means my first thoughts were alright *g*


With regards,

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