This is untested, but it should be close. Should be simple to
translate to SQL, if that's where you need it as well.
function priceFormat(num) {
var mask = ",.00";
if (num EQ int(num)) mask = ",";
return "$" & numberFormat(num, mask);
}
cheers,
barneyb
On Tue, 01 Feb 2005 15:58:38 -0400, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> Guys,
>
> Using SQL Server, small money field, trying to display my sell price the best
> way possible. Thing is, she wants just the real number displayed. So $14.00
> should be displayed as $14.
>
> Suggestions please?
>
> Thanks much!
>
> Will
>
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/
Got Gmail? I have 6 invites.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192662
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
