Update fails without blank padding.

Alessandro A. Garbagnati

Are you using a CHAR or a VARCHAR data field? I remember having the same problem with a CHAR type, and then we switched to a VARCHAR.

Joe Sam Shirah adds: In the SQL standard, CHAR is a fixed length data type. In many DBMSes ( but not all), that means that for a WHERE clause to match, every character must match, including size and trailing blanks. As Alessandro indicates, defining CHAR columns to be VARCHAR is the most general answer.