Help needed to retain character (special+alphabetic) and eliminate only numerals from email field .

[prahlad_infy]

Hello Sirs ,

Please Help to retain character (special+alphabetic) and eliminate only numerals from email field .

Example :

Thank You .

[olivierrobin · Accepted solution]

hello

use purgechar function

purgechar(email,'0123456789')