title: ASP.NET Gridview case insensitive column sorting
body: <p>I am implementing a gridview to handle a single sql server database table.  When I click to sort a column, it does so by capital letters first (e.g. Test, Test2, Test3, test1, test2).  Is there a way to manipulate the sorting so that it would return the results as expected (e.g. Test, test1, Test2, test2, Test3)?</p>