Re: case insensitive order by

Hi Malika,

You don't have to update your data, just use upper build-in function in your order by clause..

SELECT name
FROM my_table
ORDER BY upper(name);

best regards... Received on Tue Jul 01 2003 - 12:42:14 CEST