"Mario Weilguni" <mweilguni(at)sime(dot)com> writes:
> try:
> SELECT distinct foo, length(foo) from bar where foobar like 'foobar%';
> maybe one has a blank attached?
He said the column was char(6), so they should all be padded to length
6. I was wondering about nonprinting characters (carriage returns etc)
in the data, myself.
regards, tom lane