"Andrus" <eetasoft@xxxxxxxxx> writes: > I have where clause where all fields are CHAR(10) type and may have trailing > spaces. > ... > Correct result is produced if || operator does not remove trailing spaces. If you think that trailing spaces are significant data, you should probably be using VARCHAR not CHAR datatype. regards, tom lane
