Removing numbers from a string

select translate(<column>,
         'ABCDEFGHIJKLMNOPQRSTUVWXY0123456789',
         'ABCDEFGHIJKLMNOPQRSTUVWXYZ') from dual;

~ by pakcikkantin on July 17, 2008.