You just want it formatted when you select it, correct? SELECT CONVERT(varchar(10), myDateValue, 101) Cheers, Peter -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Andrew Martin 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