Code: Select all
Convert(Convert('0123456789','',YourField),'',YourField)
Do the opposite by providing a list of the alphabetic characters you'd like to keep.
Moderators: chulett, rschirm, roy
Code: Select all
Convert(Convert('0123456789','',YourField),'',YourField)