Home Forums SQL Server 7,2000 SQL Server Newbies Inserting a varchar to a date RE: Inserting a varchar to a date

  • May 3, 2005 at 8:41 am

    #556540

    Select case left(colname, 1) WHEN '0' THEN '20' ELSE '19' END + Colname as NewDateCol.