SELECT '$' + CONVERT(VARCHAR, CONVERT(MONEY, 1000000), 1)



"lamP" <phantlam> wrote in message
news:085901c347da$57a24200$a001280aphx.gbl...
> I need to format a numeric field into currency with comma
> place holder. I can use substring to format it, but it
> mbersome. Is there a quick and easy way to do it.
>
> Thanks