Home Forums SQL Server 7,2000 T-SQL Need a datetime validate function RE: Need a datetime validate function

  • May 2, 2003 at 2:30 pm

    #456071

    select * into newtable

    where isdate(hopefully_date_field) = 1

    Insert into newtable

    select field1, case field2

    when isdate(hopefully_date_field) = 1 THEN hopefully_date_field

    else null

    end

    Either of these help?



    Michelle