price field

[Garima12]

using sql server 2005.
currently using following piece of code to display numeric field like price:

CONVERT(varchar, CAST(m.V_ASSESS.TOL_AV AS money), 1) AS TOL1

it is displaying as
$123,4.00

I want to remove .00
Please suggest some solution.

thks

[ck9663]

using sql server 2005.
currently using following piece of code to display numeric field like price:

CONVERT(varchar, CAST(m.V_ASSESS.TOL_AV AS money), 1) AS TOL1

it is displaying as
$123,4.00

I want to remove .00
Please suggest some solution.

thks

What happen if there are decimal values?

-- CK