Had this same one myself this week. Float is what you want.
Dan
on 5/24/02 7:23 AM, Jason Pamental at [EMAIL PROTECTED] wrote:
> 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.
>>
>
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
215-799-0192
610-256-2843
Fax 413-410-9682
FMP,Tango, EDI,SQL 7
[EMAIL PROTECTED]
www.dss-db.com
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
