Bharath Booshan L
<[EMAIL PROTECTED]> wrote:
Consider following query
SELECT Name
FROM People
ORDER BY Name ASC;
will result as
Rajesh
Rakesh
raj
ramesh
But where as I need the output to be sorted alphabetically
irrespective of
its CASE as shown below.
ORDER BY Name COLLATE NOCASE ASC
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
