[V4MD] Order By Command

[Mahesh Markus]

I noticed that the Order By command presents its information based on
the case of the fieldText.
 
Example:
 
SELECT LastName, FirstName
FROM    tblUsers
Order By LastName, FirstName 
 
will return the following result set.
 
Admin    Admin
Admin    Elizabeth
admin     admin
admin     elizabeth
 
 
How can I make this sort order case insensitive?
 
 
Mahesh Markus
Senior Consultant
maheshm at uniqueworld.net <mailto:maheshm at uniqueworld.net> 
 

Unique World Pty Ltd

http://www.uniqueworld.net <http://www.uniqueworld.net/> 

t: (02) 9268 0269

f: (02) 9268 0278