How can I order by Greek Letters and Normal Letters in SQL Server?

Question

I have a mix of greek and normal words and now the order of these is that the normal words comes first and then all the greek words. I want them to get mixed in the order so beta in greek is the same as B.

How can I make this ORDER BY in SQL Server?

Answer 1

When ordering, you can specify the collation to use.

So, for greek you would use:

ORDER BY textField 
COLLATE 124

See a list of collations (there are several greek ones), that can be used with ORDER BY.

Answer 2

In Greek there should be both an omicron and omega (if the alphabet didn't change too much the last 2000 years :-) ). Where do you want the latin O to end up?