The Query needs to have the distinct clause in the select statement and the UPPER clause in the order by clause.
eg.
select distinct id, type from user_list order by UPPER(type)
Please let me know if there is any solution to this issue
thanks in advance.
--
Best,
Gourish Singbal
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
