Currency $ sign.....

I have a column of salary that is in money datatype and i want to format it
so the $ shows up in my table'
Thanks
S.Please disregard...I better do this on the GUI side...;-)
"SMAN" <ksanti@.nycap.rr.com> wrote in message
news:OrChakxzDHA.832@.TK2MSFTNGP09.phx.gbl...
> I have a column of salary that is in money datatype and i want to format
it
> so the $ shows up in my table'
> Thanks
> S.
>|||You beat me to it, definitely something for the front end :-)
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"SMAN" <ksanti@.nycap.rr.com> wrote in message
news:%23qGNYqxzDHA.2056@.TK2MSFTNGP10.phx.gbl...
> Please disregard...I better do this on the GUI side...;-)
>
> "SMAN" <ksanti@.nycap.rr.com> wrote in message
> news:OrChakxzDHA.832@.TK2MSFTNGP09.phx.gbl...
> > I have a column of salary that is in money datatype and i want to format
> it
> > so the $ shows up in my table'
> >
> > Thanks
> >
> > S.
> >
> >
>