ordering output

[TheConeHead]

I am using asp, vbscript and sql server 7 - hope this is the right forum... how would I change the listing order of a db... like say I am displaying colors and prices and say the db looked like:
Field Name Item Color Item Price
Field Value Red 12
Blue 20
Green 30

What command would I give to have the output display by color versus price?

 

[khorjak]

Use the following SQL statement:

SELECT * FROM TableName ORDER BY Color

Choo Khor
choo.khor@intelebill.com

 

[TheConeHead]

so would it neede to be:

objComm.CommandText = "Select *...."

??