Data Formating for export

I need to have a date that is exporting as this 2005-05-18 to export as
5/18/2005.
Is there anyway to write this into the query?I figured out my own answer CONVERT(char(10), DATE , 101)
"Diane" wrote:

> I need to have a date that is exporting as this 2005-05-18 to export as
> 5/18/2005.
> Is there anyway to write this into the query?|||convert(varchar(10),'2005-05-18',101)
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Diane" wrote:

> I need to have a date that is exporting as this 2005-05-18 to export as
> 5/18/2005.
> Is there anyway to write this into the query?