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