I installed over the weekend SQL 2008R2 Express. I imported a table tblabbreviations (ID, Abbreviation (nvarchar(10), Description Nvarchar(50).
Afterwards I added some records and created a new Query
SELECT * from dbo.tblAbbreviations
ORDER BY Abbreviation
Problem:In the rsult Nothing is sorted.
If I enter in the blank table new records via (Access Frontend)then ORDER By works fine for these records , but not when some others were imported.
I looked already on the internet and some sources say to run SQL Server Compatibility Level SQL Server 2000(80). But this did not work too.
Appreciatate any help.
Thanks in advance