order by function(value)

[lagleki]

how can I achieve select name from foo order by upper(name);? I can only find select upper(name) as uname, name from foo order by uname; but it overloads select.