>> So what type of field is COMPLAINT.ADDRESSNO ??

Varchar(10)

It contains only blanks or numeric digits. Can be blank.

I will try your other suggestions tomorrow and also look for other things
that could cause this, including a simplified example.

Marv

PS Thanks for you help.