I'm querying from Oracled db and one of my table have a field with a data type with size 38, Number(38). When i display the recordset from the query in a grid control on an ASP page, it also displays the leading 0's (38 times) up to the number. How do i go about deleting this?? Is this normal in Oracle? It displays the right number if i do:

checkfield = recSet.fields("mgcplog_id")
msgbox checkfield


Please help!!!