I have a Column in a table that stores the date. The formating on it is datetime. I pull from this column for a description that I put in another table. The description includes other thing in the string so I store it as varchar. Problem is when I cast the datetime as varchar to store it has the date 10/21/2008 12:00AM. I don't need the time on there but not sure how to get rid of it since I'm casting it as a varchar.