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