http://www.addedbytes.com/article/useful-sql-snippet/Latest comments on Useful SQL Snippet on AddedBytes.comhttp://www.addedbytes.com/article/useful-sql-snippet/comments/http://www.addedbytes.com/article/useful-sql-snippet/comments/Comment by seo la ( <a href=""></a> )<br /><br />Benjamin's solution is amazing. <br />Nice way to use logical expressions for sql queries, i was looking for thathttp://www.addedbytes.com/article/useful-sql-snippet/comments/http://www.addedbytes.com/article/useful-sql-snippet/comments/Comment by Dave Child ( <a href="http://www.addedbytes.com">http://www.addedbytes.com</a> )<br /><br />Hi Benjamin, <br /> <br />I am using a very odd version of MySQL indeed ... SQL Server :) <br /> <br />Probably should have made that clearer before. Sorry.http://www.addedbytes.com/article/useful-sql-snippet/comments/http://www.addedbytes.com/article/useful-sql-snippet/comments/Comment by Benjamin Wilger ( <a href=""></a> )<br /><br />hm sounds strange. Maybe you use a very old version of MySQL (3.23)? MySQL should allow expressions inside of ORDER BY clauses in Versions above 4. <br /> <br />Greetings, <br />Benhttp://www.addedbytes.com/article/useful-sql-snippet/comments/http://www.addedbytes.com/article/useful-sql-snippet/comments/Comment by Dave Child ( <a href="http://www.addedbytes.com">http://www.addedbytes.com</a> )<br /><br />I had some problems with Benjamin's solution (kept getting an error saying "Incorrect syntax near '>'."). I changed it to this (virtually the same) and it worked fine: <br /> <br />ORDER BY (cast(ProductStock as bit)) DESChttp://www.addedbytes.com/article/useful-sql-snippet/comments/http://www.addedbytes.com/article/useful-sql-snippet/comments/Comment by Tino ( <a href="http://computeragency.de">http://computeragency.de</a> )<br /><br />Can't believe - it works. Thanks lot!http://www.addedbytes.com/article/useful-sql-snippet/comments/http://www.addedbytes.com/article/useful-sql-snippet/comments/Comment by The King ( <a href="http://adiazar.blogspot.com">http://adiazar.blogspot.com</a> )<br /><br />Thanks for sharing!http://www.addedbytes.com/article/useful-sql-snippet/comments/http://www.addedbytes.com/article/useful-sql-snippet/comments/Comment by Ad ( <a href="http://www.adiazar.com">http://www.adiazar.com</a> )<br /><br />Benjamin rocks!http://www.addedbytes.com/article/useful-sql-snippet/comments/http://www.addedbytes.com/article/useful-sql-snippet/comments/Comment by Bandolino ( <a href="http://www.bandolinoshoes.us/">http://www.bandolinoshoes.us/</a> )<br /><br />Thanks Benjamin, That's indeed a great solution. :)http://www.addedbytes.com/article/useful-sql-snippet/comments/http://www.addedbytes.com/article/useful-sql-snippet/comments/Comment by Loke Krongaard Hansen ( <a href="http://pagerank-boost.com">http://pagerank-boost.com</a> )<br /><br />A plain and elegant solution indeed. <br />Both thumbs up !!http://www.addedbytes.com/article/useful-sql-snippet/comments/http://www.addedbytes.com/article/useful-sql-snippet/comments/Comment by Guilherme Zühlke O'Connor ( <a href="http://www.z-oc.com">http://www.z-oc.com</a> )<br /><br />Ben, yours is a very nice and elegant solution. <br /> <br />I understood it when I saw it, that's why I said it makes sense, but I wouldn't have think of it myself, I guess (Perhaps now I would...) <br /> <br />I would be searching for a number, not a "boolean" for that field.