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

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 t开发者_如何学JAVAhem 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?

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.

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?