SQL query

[KOS]

Hi
I making a web page and
I trying to sort a table fram access.

table name: lopere
colum1 name: name
colum2 name: class

in colum 1 i have the name of some people
in colum 2 i have god, best and better.

i want to sort first all that has "better" and then "best" and finaly
"god".

How do i write sql statment???

Kjell

[CryingClinton]

"KOS" <ma**********@ONLINE.NO>

Hi
I making a web page and
I trying to sort a table fram access.

table name: lopere
colum1 name: name
colum2 name: class

in colum 1 i have the name of some people
in colum 2 i have god, best and better.

i want to sort first all that has "better" and then "best" and finaly
"god".

How do i write sql statment???

Kjell

Use datatype 'Enum' for this field.

See the manual for detail of ENUM

ccton
--
http://www.vicdir.com