Subject Re: [firebird-support] Re: 'like' with % at the begin finds nothing
Author Nando Dessena

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.

Nando Dessena
I support Firebird, I am a Firebird Foundation member!
Join today at