>It is possible. Simply use CASE statement, e.g.
>

> select case when MyColumnName NOT LIKE '%[^0-9]%' then 0 else convert(int, MyColumnName) END as Converted
>

>
>Also, in SQL 2012 you may want to look at TRY_CONVERT function.

Thanks