alfabetisk pager

Select Distinct 
   Upper(Left(Title,1))[PageText], 
   Upper(Left(Title,1)) [PageIndex] 
from 
   Cars 
Order By 
   PageText COLLATE Danish_Norwegian_CI_AS Asc

Select Distinct 
   Upper(Left(Title,1))[PageText], 
   Upper(Left(Title,1)) [PageIndex] 
from 
   Cars 
Order By 
   Title COLLATE Danish_Norwegian_CI_AS Asc

List<string> allList = new List<string>() {"A", "B", "C" ,...};
List<string> linkList = new List<string>();
foreach (DataRow row in dtSelect.Rows)
{
   linkList.Add((string)row["PageIndex"]);
}
List<string> noLinkList = allList.FindAll(pi => !linkList.Exists(lnk => lnk == pi));

Select Distinct 
   Upper(Left(Title,1))[PageText]
from 
   Cars 
Order By 
   Upper(Left(Title,1)) COLLATE Danish_Norwegian_CI_AS Asc

CREATE VIEW vAlphabet
AS
Select Distinct 
   Upper(Left(Title,1)) COLLATE Danish_Norwegian_CI_AS As Title
from 
   Cars 
GO

SELECT 
   Title
FROM
   vAlphabet
Order By 
   Title

DECLARE @Cars1 TABLE (
    Title varchar(1) COLLATE Danish_Norwegian_CI_AS
)
DECLARE @Cars2 TABLE (
    Title varchar(1) COLLATE French_CS_AS
)

INSERT INTO @Cars1 (Title)
SELECT 'c' UNION
SELECT 'æ' UNION
SELECT 'a' UNION
SELECT 'ø' UNION
SELECT 'b' UNION
SELECT 'å' UNION
SELECT 'i' UNION
SELECT 'h' UNION
SELECT 'q' UNION
SELECT 't'

INSERT INTO @Cars2 (Title)
SELECT 'c' UNION
SELECT 'æ' UNION
SELECT 'a' UNION
SELECT 'ø' UNION
SELECT 'b' UNION
SELECT 'å' UNION
SELECT 'i' UNION
SELECT 'h' UNION
SELECT 'q' UNION
SELECT 't'

SELECT 'Dansk', Title FROM @Cars1 ORDER BY Title
SELECT 'Fransk', Title FROM @Cars2 ORDER BY Title
SELECT 'Fransk > Dansk', Title FROM @Cars2 ORDER BY Title COLLATE Danish_Norwegian_CI_AS