Currency Format with Comma Delimination

From: Dan (dannyjoered_at_aol.com)
Date: 06/02/04 

Date: Tue, 1 Jun 2004 17:32:04 -0700

Is there a way to convert a field to Currency format with
a comma as a seperator.

ie
50000 would be $50,000
1234567 would be $1,234,567
etc.

I am just looking to do this via the SELECT statement.
Any suggestions would be helpful.