>Has anyone had problems with Sorts not properly working with mysql if there is any null values within a field. If so, how do you fix it? Ex: lower case will be mixed in among upper case text. This should not happen based on the ascii values. Any suggestions would be greatly appreciated.
>
>Sue

Hmm... with SQL Server it depends on your collation setting of the table. Have you tried to ORDER BY upper(fieldname) ?

BOb