Not sure this is the right question for this forum, but maybe somebody has
an idea.
Have a case of a FB 1.5 (Classic) database on Windows where certain records
in two fields of one table show fine in one application, but show truncated
in another, that is only the first 4 characters show. First application
accesses the database via the API and the second via ODBC.

This is the schema of that table:

CREATE TABLE ADDRESS(
ADDRESS_ID INTEGER NOT NULL,
ADDRESS_LINE_1 VARCHAR(40),
POSTCODE CHAR(10),
UPDATED_DATE INTEGER,
ADDRESS_LINE_2 VARCHAR(40),
ADDRESS_LINE_3 VARCHAR(40),
ADDRESS_LINE_4 VARCHAR(40),
ADDRESS_LINE_5 VARCHAR(40))

The problem shows in ADDRESS_LINE_3 and ADDRESS_LINE_4, but only in a few
records.
ADDRESS_LINE_2 has an index, but ADDRESS_LINE_2 hasn't.

The question is how to figure out what is wrong with the particular records.
My guess is that somehow wrong characters
got into the text, maybe Chr(0), but I can't see it in my programming
environment, which is VB.
Is there a way with SQL to see what might be the trouble here?
Thanks for any advice.

RBS