Storing Greek Symbols in SQL Server 2000

EDIT: Replace previous code snippets with 1 complete snippet using a table variable.

You should be able to do this using a Greek collation for an nvarchar column.

I found this page with Greek characters: http://ancienthistory.about.com/od/greeklanguage/a/ASCIIGreek.htm

DECLARE @GreekAlphabet TABLE
(
    english nchar(1) not null,
    greek nchar(1) COLLATE Greek_BIN not null,
    greek_name varchar(10) not null
)

INSERT INTO @GreekAlphabet (english, greek, greek_name)
    SELECT N'A', N'Α', 'ALPHA'
    UNION
    SELECT N'a', N'α', 'alpha'
    UNION
    SELECT N'B', N'Β', 'BETA'
    UNION
    SELECT N'b', N'β', 'beta'
    UNION
    SELECT N'G', N'Γ', 'GAMMA'
    UNION
    SELECT N'g', N'γ', 'gamma'
    UNION
    SELECT N'D', N'Δ', 'DELTA'
    UNION
    SELECT N'd', N'δ', 'delta'

SELECT * FROM @GreekAlphabet

Results:

english greek	greek_name
A   Α	ALPHA
a   α	alpha
B   Β	BETA
b   β	beta
D   Δ	DELTA
d   δ	delta
G   Γ	GAMMA
g   γ	gamma