I have a column (char) with info like 200401, how to insert this into atable in a column with a date type in SQL server 2000.I appreciate any idea..MS Sql Server LazyDBA home page