Arno,

<< Why does Locate('Name', 'foo ', []) return true even though there's just
a record with Name = 'foo' (no trailing space)? >>

Trailing spaces are discarded when comparing VARCHAR columns:

http://dba.stackexchange.com/questions/10510/behavior-of-varchar-with-spaces-at-the-end

EDB does so consistently, though, and does not make an exception for LIKE
comparisons like SQL Server does.

Tim Young
Elevate Software
www.elevatesoft.com