When I perform this query to the database : "SELECT Name FROM Thirds ORDER BY Name;", here is what I obtain :
Celine C�line Eric Marc �ric Zoe c�line eric �ric �ric
This does NOT appear ordered to me...
Moreover, it does not appear correct! "�ric" appears twice, once before "Zoe" and again before "�ric". Why is that?
Is there something I should know that I don't about how SQL interpret capital letters ?
It looks like it is going on strict ASCII numeric order (a la strcmp), with the exception of the error I mention above.
michael
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
