i need to copy record of one table to another but before doing it, i need to convert my date stamp column (nvarchar) in datetime format because the date there is in varchar format and because of which i m not able to query the table. I know how to convert the varchar in datetime format, but it is for a single record. Can any one refer me a simple and fast way to do this that convert the the whole column in date time format and then copy record to another table.the e.g. format of the varchar datestamp is wenesday, january 16, 2013.i need to copy record of one table to another b