hello i m using sql server 2008 i am having a problem with one of my column . i have a coulumn date_created which have data type of varchar(10) when i use this coulmn in any where condition it does not give proper result . i.e if i use date<date_created , it doesnt identify the value in date_created . how can i convert this varchar data type to date .