Thanks Bill, Len, and Tom:
You suggestion of
select distinct trim(name) as foo .... order by trim(name);
works wonderfully.
I do have another question about this though. Why does it this command work
select name as foo .... order by trim(name);
when this does not
select distinct name as foo .... order by trim(name);
Once again, thanks a million.
Brett