>The SQL SELECT ORDER BY treats "W" and "V" characters as equal. Is there any way to make it understand that they are different characters?
How SQL Server compares or sorts data in a column depends on columns collation. You can specify different collation the the ORDER BY clause. For example
ORDER BY mycolumn1 COLLATE Latin1_General_CI_AS
--sb--