Home Forums SQL Server 7,2000 SQL Server Newbies Inserting a varchar to a date RE: Inserting a varchar to a date
Ninja's_RGR'us
SSC Guru
Points: 294069
More actions
May 3, 2005 at 8:41 am
#556540
Select case left(colname, 1) WHEN '0' THEN '20' ELSE '19' END + Colname as NewDateCol.