Hi All,
Eg:
People table
| EmpID | Name |
21 Rajesh
22 raj
23 Rakesh
24 ramesh
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.
ramesh
raj
Rajesh
Rakesh
Please anyone suggest me regarding this.
Thanks in advance,
Bharath Booshan L
-----------------------------------------------
Robosoft Technologies - Come home to Technology
Disclaimer: This email may contain confidential material. If you were not an
intended recipient, please notify the sender and delete all copies. Emails to
and from our network may be logged and monitored. This email and its
attachments are scanned for virus by our scanners and are believed to be safe.
However, no warranty is given that this email is free of malicious content or
virus.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
