Convert Char Data Type to smalldatetime
I have a data stored in SQL database. I will called it ship_date. ship_date Data Type is CHAR. The records are stored like this 01/01/05, 02/05/05. I need to filter it using between 01/01/05 to 02/03/05, but since the Data Type is CHAR. the SQL command Between fails. How can I Filter it without changing the Data type directly to the database.
Thanks In advance.