469,126 Members | 1,277 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

price field

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
Mar 26 '08 #1
1 1106
ck9663
2,878 Expert 2GB
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
Mar 26 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by Ed | last post: by
3 posts views Thread by Gigi.com | last post: by
6 posts views Thread by Patrick Fisher | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.