Data Types Question and Help

Hi Experts,
I dont want to use money data type because the money symbol pops into the
the grid but yet i am little uncomfortable with double - my calculations are
likely to go upto 50 Millions and cents rounded off to 4 decimal. Can you
please make a suggestion in this regard. Your help would be greatly
appreciated
Best Regards
Manish Sawjiani
Three Cheers to Technet for the Help!
How about a suitable DECIMAL() or NUMERIC() datatype?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in message
news:EA8D18EF-C8B7-45D7-A189-3F751B4FD491@.microsoft.com...
> Hi Experts,
> I dont want to use money data type because the money symbol pops into the
> the grid but yet i am little uncomfortable with double - my calculations are
> likely to go upto 50 Millions and cents rounded off to 4 decimal. Can you
> please make a suggestion in this regard. Your help would be greatly
> appreciated
> Best Regards
> Manish Sawjiani
> --
> Three Cheers to Technet for the Help!

Data Types Question and Help

Hi Experts,
I dont want to use money data type because the money symbol pops into the
the grid but yet i am little uncomfortable with double - my calculations are
likely to go upto 50 Millions and cents rounded off to 4 decimal. Can you
please make a suggestion in this regard. Your help would be greatly
appreciated
Best Regards
Manish Sawjiani
--
Three Cheers to technet for the Help!How about a suitable DECIMAL() or NUMERIC() datatype?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in messag
e
news:EA8D18EF-C8B7-45D7-A189-3F751B4FD491@.microsoft.com...
> Hi Experts,
> I dont want to use money data type because the money symbol pops into the
> the grid but yet i am little uncomfortable with double - my calculations a
re
> likely to go upto 50 Millions and cents rounded off to 4 decimal. Can you
> please make a suggestion in this regard. Your help would be greatly
> appreciated
> Best Regards
> Manish Sawjiani
> --
> Three Cheers to technet for the Help!