Again thank you Helen.

I will keep these words in mind.

The database itself is a new design. But I will take a closer look at
the char/varchar issues.

In code I have been using the right trim function in delphi when
pulling the data for comparision.