>>I'm writing an .asp application using VFP tables. One table has a field "Price" which is defined as N(10,2). When the records are selected and displayed via
>>
>>response.write(oDatarecord("Price"))
>>
>>the result does not include the zero value decimals. Thus 1.00 becomes 1 and 1.20 becomes 1.2. So my question is:
>>
>>Is there a function similar to VFP's transform or padr that would force the zero decimals to display? I apologize if this is too far off topic for this list but I don't know where else to turn.
>>
>>Thanks
>
>If I recall correctly, you may want to use FORMAT function to display record in the correct format.
>
>A while ago I used tek-tips.com forum for ASP questions.

You are right! I found

< %Response.Write FormatCurrency ( oDatarecord("bidprice"), 2, -2, -2, -2)% >

which works great.

Thanks