Convert varchar value to int without throwing an exception in case of bad input

In SQL Server 2012 there are functions for this

try_cast
try_convert
try_parse

select case when isnumeric(YourColumn + '.0e0') = 1 
            then cast(YourColumn as int) 
            else NULL 
       end /* case */
    from YourTable