Multicolumn sorting with condition?

[lgomez]

Hi,

I have a table with a column for regular price and a column for special price. I need to sort by the lowest price.

If a particular record contains a special price sorting should use this price instead of the regular price.

Basically I have to ignore the regular price if a special price is not 0.00.

Can I do this in SQL [MySQL 4.012]?

If so, how?

Thank you,

[MarcusJT]

This is for SQL Server (off the top of my head though), so you may need to make slight changes for MySQL syntax:

SELECT .....
FROM .....
WHERE .....
ORDER BY IIF([SPECIALPRICE]>0,[SPECIALPRICE],[NORMALPRICE])