How can I order Greek letters and regular letters on SQL Server?

Question

I have a mixture of Greek and normal words, and now their order is that ordinary words first appear, and then all Greek words. I want them to mix in order, so beta in Greek is the same as B

How can I do this ORDER BY in SQL Server?

Answer 1

When ordering, you can specify the mapping to use.

So for the Greeks you will use:

 ORDER BY textField COLLATE 124 

See the list of sorts (there are several Greek ones) that can be used with ORDER BY .

Answer 2

In Greek, there should be both omicron and omega (if the alphabet has not changed too much over the past 2000 years :-)). Where do you want Latin O to graduate?