• I don't know if you want to use a temp table but this should work

    select *

    into #temp

    from emp

    where isDate(fromdate) = 1

    select fromdate

    from #temp

    where cast(fromdate as datetime)>'2/16/2007'