I have a view from which I select values, but I need to do a 'SELECT
DISTINCT' query on a 'varchar' column and order by lower case eg:
SELECT DISTINCT name FROM someview ORDER BY lower(name)
Obviously this doesn't work with the 'DISTINCT' but is there any way to do
it apart from:
SELECT v.name FROM (SELECT DISTINCT name FROM someview) v ORDER BY
lower(v.name)
Or is this the most efficient way?
Thanks
Jake