How to convert varchar to number : <p>I have character string as '00000625710' I want it as number 6257.10 how can I do that . I tried as follow 
<code>select to_number('00000002511','999999999.99')from dual;</code></p>

<p>But didn't work . can any one help me in this . Thank you.</p>
