Format Date Problem

How do I format a date stored into a table as:

2002-02-28 00:00:00.0

into

02/28/2002

The sql statement is:

SELECT PAYPERIOD
FROM PAYPERIOD_Table
ORDER BY PAYPERIOD ASC Any help would be appreciated.

Thanks

Jennifer Received on Mon Apr 21 2003 - 08:45:58 CDT