SQL Function to Remove Alphanumeric Characters – azurecurve

Microsoft Dynamics GPI 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…

Continue Reading Ian Grieve’s Article on their blog

SQL Function to Remove Alphanumeric Characters – azurecurve

Blog Syndicated with Ian Grieve’s Permission

Author: Ian Grieve

Share This Post On