• Here is a nice article which shows you why one would use this expression:

    http://www.sqlservercentral.com/articles/IsNumeric/71512/