ORDER BY - med hensyn til æ, ø og å

lytter med ...

Here you got your answer ;o)

http://www.eksperten.dk/spm/265859

//>Rune

Medions: Ikke rigtig svaret... Men, Brug Books Online

are fundamental to the structure of all databases. In order to change one or more of the character set, sort order, and Unicode collation settings for the server, you must rebuild the master and user databases.

Use the Rebuild master (rebuildm) utility to change the character set, sort order, or Unicode collation.

But, databases can have a different collation to the server default under SQL 2000 (thank god). If it is only one database it is possible to change the collation using ALTER DATABASE and ALTER TABLE, again look it up in Books Online, there is a good brugervejlinding (or whatever the hell it's called).

select Navn collate Danish_Norwegian_CI_AS
order by Navn Danish_Norwegian_CI_AS

Herligt !!! Jeg fandt hjælp i alle 3 kommentarer - TAK  ;)  - I får hver 10 point

Fair nok :o)
Thx 4 Poinz

//>Rune