select replace(CONVERT(CHAR(10),getdate(),101), '/', '')

John

-----Original Message-----
From: Andrews, Daryl [mailto:[Email Address Removed]
Sent: Thursday, January 29, 2004 12:55 PM
To: LazyDBA.com Discussion
Subject: Date Styles

I'm trying to create a date string of MMDDYYYY. There is no standard
"style" that I can find for this. However, I can get MM/DD/YYYY,

CONVERT (CHAR(8),L.CURRENTDATE,101)

but can't seem to put the "replace" statement in the right place to pull
out
the "/". Any ideas?

Thanks!

Daryl


MS Sql Server LazyDBA home page