I found a very cialis cheap good article on “Short-Circuiting in SQL” at the below link, but unfortunately you need a userid and password to view the post. I am copy pasting a useful thing from there.
http://www.sqlservercentral.com/articles/T-SQL/71950/
SELECT TOP 5 *
FROM #Test
WHERE ISNUMERIC(b)= 1 AND b < 10
In column b there is some alpha numeric and numeric data