In reply to Sandesh.

You can use the COMPRESS function to achieve this, removing just the digits. Example:

result = compress(field,,'d'); /* the 'd' indicates to remove digits */