Brad, Either �money� or �decimal� should work � as long as the decimal type is set for precision of 2. Check your db to make sure that the values are correct by using the Enterprise manager to look directly at the table data... I�ve had a number of frustrating experiences not realizing that it is fine in the DB but not in my query statement. When Witango pulls the data, all it knows is that it�s a number, so it loses the trailing 0. You can solve this by either using the @PAD tag or by using a �format=� statement in your tag that displays the values. There are some good examples in the early pages of the Meta Tag book/pdf. (can�t remember off the top of my head the exact syntax)
Hope this helps... Jason On 5/24/02 2:24 AM, "Brad Robertson" <[EMAIL PROTECTED]> wrote: > > 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. > -- ____________________________________________________________________ Jason Pamental, President [EMAIL PROTECTED] Bathysphere Digital Media Services, Inc. http://bathyspheredms.com ____________________________________________________________________ Tel: 401.490.6830 Fax: 401.490.6831 ________________________________________ ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
