Ian Grieve gives us a SQL Function to Remove Alphanumeric Characters at www.azurecurve.co.uk/2019/05/sql-function-to-remove-alphanumeric-characters/
SQL Function to Remove Alphanumeric Characters – azurecurve
SQL & DataMicrosoft & the GP Ecosystem
Archived post from 2019. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.