>- see footer for list info -< > I have also tried using DatePart() with the same result. Surely these > functions should not do this ?
They're converting it to numeric - most times that's probably what you want. What about converting to varchar then use Mid() on the resulting string? Or possibly clearer doing a Right( '0' + value , 2 ) _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
