!!!TO_NUMBER 
!Functionality:
This Oracle function converts a string to a number

!Parameters:
|NUMBER    | the text string
|Format    | (optional) the format that the string is in – generally not used

!Returns: 
Number

!Errors:  
None

!Operations: 
This function is when Oracle (which normally does conversions for you automatically) needs guidance to convert numbers from text for arithmetic operations.  You may find this needed to do numeric (rather than text) comparisons of values.  It is recommended that you do explicit data conversions as you may get unexpected results when allowing Oracle's implicit conversion to take place.
 
!Example:

{{to_number(~)||  will return 123.55 when the value is ‘123.55’


----
![Notes|Edit:Internal.TO_NUMBER] 	
[{InsertPage page='Internal.TO_NUMBER' default='Click to create a new notes page'}]