SQL Server 2000 dataset sorting question

[twhitney]

I'm trying to sort a SQL query while prioritizing one specific dataset - e.g.:

table: tbl_properties
field: prop_firmID

I want to list those properties where prop_firmID=32
and second, by price (which I got covered)


In other words - If I sort by prop_firmID - it will list properties associated with prop_firmID=1 first - is there a way to prioritize a specific ID value without creating another sort column?

 

[PHV]

Something like this ?
ORDER BY CASE WHEN prop_firmID=32 THEN 0 ELSE prop_firmID END, price

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[twhitney]

PHV - thanks - that looks good - I just tried this and it seemed to work:

ORDER BY CASE WHEN prop_firmID = 32 THEN prop_firmID ELSE prop_price END

I might try yours too.

Thanks again!!