SQL Function to Remove Alphanumeric Characters – azurecurve

Ian GrieveDyn365GP6 years ago114 Views

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

0 Votes: 0 Upvotes, 0 Downvotes (0 Points)

Join Us
  • X Network2.1K
  • LinkedIn3.8k
  • Bluesky0.5K
Support The Site
Events
August 2025
MTWTFSS
     1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
« Jul   Sep »
Follow
Search
Popular Now
Loading

Signing-in 3 seconds...

Signing-up 3 seconds...