How to convert string into number ...

[msng]

how do I convert string to a number value. I have the database field value as 1 which is of the type string. I have to convert this value 1 into number datatype and add 1 to it.

Please let me know.

Thanks in advance for your help.

 

[TruthInSatire]

in cf if you have
<cfset charNum = "1"> <!--- string because it is in quotes --->
you can do math with any math operator
<cfset charNum = charNum+charNum>
<!--- this produces 2 --->
you can do string functions with it using the & symbol

<cfset charNum = charNum&charNum>
<!--- this will make "22" --->
<cfset charNum = charNum + 1>
<!--- this will give you 23 --->

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)

 

[TruthInSatire]

oops sorry wasn't done yet

here is your proof

<cfoutput>
<cfset charNum = "1"> 
#charNum# *1*<br>
<cfset charNum = charNum+charNum>
#charNum# *2*<br>
<cfset charNum = charNum&charNum>
#charNum# *22*<br>
<cfset charNum = charNum + 1>
#charNum# *23*<br>
</cfoutput>

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)