Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brubaker
Starting Member
15 Posts |
 Posted - 2001-11-23 : 16:26:50
|
| I would like to sort by a column in a table that guages the interest a user has. This column has 3 possible values: High, Medium, LowIf I use ORDER BY interest ASC I get the following order: HIGH, LOW, MEDIUM. If I use ORDER BY interest DESC I get the following order: MEDIUM, LOW, HIGH.How do I return the proper order of LOW, MEDIUM, HIGH or HIGH, MEDIUM, LOW? |
|
|
|
|
|
Sorting by a user defined value?