Bharath Booshan L <[EMAIL PROTECTED]> wrote: > > Consider following query > > SELECT Name > FROM People > ORDER BY Name ASC; >
SELECT Name FROM People ORDER BY Name ASC COLLATE nocase; The nocase collating sequence only works for US-ASCII characters. If you need UTF-8 you will need to use a different collating sequence. But the principle is the same. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------