>>>>>select dist fundtype, ; >>>>> cast(000000000000.00 as N(15,2) NULL) as priorpmt,; >>>>> cast(0000000000 as I NULL) as thisyear, ; >>>>> cast(0000000000.00 as N(13,2) NULL)as spent, ; >>>>> cast(0000000000.00 as N(13,2) NULL) as currentbalance, ; >>>>> cast(0000000000 as I NULL) as futureprogram, ; >>>>> cast(0000000000.00 as N(13,2) NULL) as total ; >>>>> from tipdatabase!fundtypes ; >>>>> order by fundtype ; >>>>> into cursor crsTemp readwriteso the datatype for thisyear is integer although there are also number fields I will have to deal with in similar fashion. I think my second sample was taken directly from the site shown in your link.
Dim myval As Decimal = oReader("priorpmt") Response.Write(myval.ToString("$ #0,0.00"))will work, but
Response.Write(oReader("priorpmt").ToString("$ #0,0.00"))will not. So it looks like the reader is presenting a string and not a number.