I am doing ASP with my personal Oracle database. When I use a recordset to retrieve rows from a table and trying to assign those to variables in my ASP code, char type seem to work but any numeric type doesn&#039t. For e.g If I select two columns namely Empnumber(integer) and empName(char) then the following code works<BR><BR>var1=RS("empName")<BR><BR>but the follwing one doesn;t work.<BR>var1=RS("Empnumber") &#039this one is numeric type<BR><BR>I have tried converting it to TEXT or Int using functions like CStr and CInt but nothing seem to work.<BR><BR>Generally I am having problems with numeric data type.<BR><BR>Please Help. Thanks so much.