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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
