Don't you just want to FORMAT the data when you display it? How it is
stored in the database doesn't really matter does it? If the value was
23.31, it would be stored that way, so you are not risking an integrity
issue. You could use a format function to set it to as many decimals as
you like.
Regards,
Len Wright
Plus International Corp
www.plusinternational.com
Direct: 604-415-2384
Fax:604-415-0830
>>> [EMAIL PROTECTED] 05/23/02 11:24PM >>>
Anybody know a SQL Server 7 DataType that will hold a number like 23.30
and not 23.3? I tried all kinds of variations of money, smallmoney,
numeric, and decimal.
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
