I need to make SQL queries which would allow me to order the data in a table by different alphabets (sort orders). I have one table with text data and I need to make 2 queries. The First query would order the data by the standard English alphabet (I suspect it is called Latin1 in computer usage). But now, I need to use the same table and make a second query which would order the same data according to the different alphabet (Czech alphabet - I suspect it is called CP1250 in computer usage) - however, in both cases, I do not know the correct collation names for these alphabets for use in Access. If I am not mistaken, I think there should exist a COLLATE statement in the SELECT clause, but I cannot find the correct syntax for the COLLATE statement. Whenever I use the word COLLATE in a SELECT, Access tells me that there is incorrect syntax near this word.
For English I was trying to do this:
SELECT Data
FROM Table
ORDER BY Data
COLLATE SQL_Latin1_General_CP1_CS_AS;
Could you please help me?