Is there a way to not have sql server strip the 0 from a date such as: 04/04/2005? I could store the date as text instead of datetime but that just seems wrong. Any ideas? Thanks