changing txt to number

I am using access DB.
i have a large table that i have aquired, and all the data in the fields are
actually txt. unfortunatly, the data is integers stored as txt. the future
plan, is to redo the DB, and make the fields numeric, but for now, i need a
way to retrieve data, and change it to numeric.

so if field cc_callNumbers is a 7.. but the field type is txt, in my asp
page i can call that as say

var1 = sales_data.fields.item("cc_callNumbers").value

that value returns a txt 7, but i need to convert it to a number 7, so i can
do math with the data. is this possible?
thanks
jeff


.

Relevant Pages

  • Re: Double click
    ... Jeff wrote on 12 jun 2005 in microsoft.public.inetserver.asp.db: ... ASP runs serverside and does know noting about clicking. ... (Replace all crosses with dots in my emailaddress) ... Prev by Date: ...
    (microsoft.public.inetserver.asp.db)
  • Re: changing txt to number
    ... this will convert the string type of number into Integer ... > do math with the data. ... Prev by Date: ...
    (microsoft.public.inetserver.asp.db)
  • Re: WMI in ASP fails on 2003 (err 80041003); works fine on 2000
    ... Second - I have two production 2000 servers here that process the WMI in ASP ... > Hi Jeff, ... >> the WMI script uses delegation to reach the remote machine. ...
    (microsoft.public.win32.programmer.wmi)
  • Re: How old do you have to be to play?
    ... I gotta agree with Jeff on this one. ... The teachers down here already make more than the ... The math I basically taught them some shortcuts ...
    (rec.sport.paintball)
  • Re: ASP Events and Participation - Swap Ideas
    ... Maybe a secret santa should wait 'til next year. ... Tonight on ASP ... >>Jeff Horn ... > Well Jeff I've already participated in 2 box passes on YPSC and I'm ...
    (alt.smokers.pipes)