GridView.Sort <> SQL 'ORDER BY'. what's up with that?!?

[Ryan H]

Given 2 records with 1 'Name' column (varchar):
"Tri-Star"
"Triangle"

GridView.Sort("Name", SortDirection.Ascending) will sort the records like
so:
1. "Triangle"
2. "Tri-Star"

While a standard SQL 'SELECT * FROM MyTable ORDER BY Name ASC' will sort the
records like so:
1. "Tri-Star"
2. "Triangle"

This is lame. Is there a fix for this?

 

[Cowboy \(Gregory A. Beamer\)]

Sort in SQL?

Currently, I know of no other fix for the problem.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*********************************************
Think outside the box!
*********************************************

 

[Ryan H]

Oh well. I like your books btw.

Sort in SQL?

Currently, I know of no other fix for the problem.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*********************************************
Think outside the box!
*********************************************