Roger,

R> Thanks for the answer, but the suggestions to work around
R> do not help me because
R> o I have no influence on the db structure (it's not mine)

not even adding a COMPUTED BY column or a VIEW?

R> o To pad the compare string at the end with blanks you need to
R> to know the correct number of blanks at the end of the entry.

you could also try the RTRIM UDF.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================