using SQL to order select ignoring case

[william humphrey]

Why doesn't this simple SQL work?

select s_fullname from ships order by upper(sname)

I get error unexpected token "upper".

of course

select s_fullname from ships order by sname

does work but I want the sort to ignore case
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120512/76cf2403/attachment.html>