471,092 Members | 1,539 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

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
Jul 20 '05 #1
1 1321
"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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by jaysonsch | last post: by
9 posts views Thread by netpurpose | last post: by
3 posts views Thread by Harvey | last post: by
4 posts views Thread by Diamondback | last post: by
14 posts views Thread by Dave Thomas | last post: by
4 posts views Thread by Stan | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.