Reputation: 83

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 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?

Upvotes: 4

Answers (2)

Hans Keﬆing

Reputation: 39284

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?

Upvotes: 0

Oded

Reputation: 499062

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.

Upvotes: 1

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

Answers (2)

Related Questions