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.
Elmer

Try this:

WHERE
   Convert(datetime, ship_date ) BETWEEN '01/01/05' AND '02/03/05'

Great it works thanks jbenson, I really appreciate your help.

Elmer

Not a problem, glad I could help and glad it works!

Jim