I am looking up a text field (DefaultOrderType) in the Orders table from the Suppliers table, based on a number (SupplierID).
In the Suppliers table the DefaultOrder type is "n" characters long (e.g. 6 chars, "IN-OUT")
In the Orders table the looked-up DefaultOrderType will be n+1 characters long (e.g. 7 chars, "IN-OUT¶") – thus a carriage return [ char(13) ] is added during the lookup.
I believe this is some unexpected behaviour.