SQL Function to Remove Alphanumeric Characters – azurecurve

I created a customisation recently for a client which would generate a Vendor ID based on the name, by removing alphanumeric characters. In order to make it as flexible as possible, I created the function to accept a parameter for type which will cause the function to strip different characters:

• A – leaves alpha characters only.
• N – leaves numeric characters only.
• AN – leaves…