Val  
Description
Converts numeric characters that occur at the beginning of a string to a number.
 
Returns
A number. If conversion fails, returns zero.
 
Category
Conversion functions, String functions
 
Function syntax
Val(string)
 
See also
IsNumeric
 
Parameters
 
Parameter      Description
string A string or a variable that contains one
 
Usage
This function works as follows:
  • If TestValue = "234A56?7'", Val(TestValue) returns 234
  • If TestValue = "234'5678'9?'", Val(TestValue) returns 234
  • If TestValue = "BG234", Val(TestValue) returns the value 0, (not an error)
  • If TestValue = "0", Val(TestValue) returns the value 0, (not an error)
 
Example
<h3>Val Example</h3>
<cfif IsDefined("FORM.theTestValue")>
   <cfif Val(FORM.theTestValue) is not 0>
      <h3>The string <cfoutput>#DE(FORM.theTestValue)#</cfoutput> 
can be converted to a number:
      <cfoutput>#Val(FORM.theTestValue)#</cfoutput></h3>
   <cfelse>
      <h3>The beginning of the string <cfoutput>#DE(FORM.theTestValue)#
       </cfoutput> cannot be converted to a number</h3>
   </cfif>
</cfif>
<form action = "val.cfm">
<p>Enter a string, and determine whether its beginning can be evaluated 
to a numeric value.
<p>
<input type = "Text" 
   name = "TheTestValue" 
   value = "123Boy">
<input type = "Submit" 
   value = "Is the beginning numeric?" 
   name = "">
</form>
string  
A string or a variable that contains one