January 18th, 2001, 01:51 PM
oracle NUMBER data type
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")
Click Here to Expand Forum to Full Width
This a Codeguru.com survey!