Conversion of to_char into number format!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • richasaraf
    New Member
    • Aug 2005
    • 23

    Conversion of to_char into number format!

    Hi all,
    Please help me out... i want to convert the to_char into number format....
    please let em know how to do it...
    for eg:
    i have a statement : to_char(p_numbe r, 'S000000')
    this converts the number into proper format....
    now i want to convert tht 'S000000' char back to the original number p_number.....
    Can anyone tell me how to do it please :confused:

    Thanks a lot
    :)
Working...