> i am just experiencing something weird:
>
> select distinct foo from bar where foobar like 'foobar%';
>
> gives:
>
> foo
> --------
> 090700
> 090701
> 090702
> 090700
> (4 rows)
>
try:
SELECT distinct foo, length(foo) from bar where foobar like 'foobar%';
maybe one has a blank attached?