SQL Scripts for Microsoft Dynamics GP: Get Alpha Characters from an Alphanumeric String

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.

This script will return all of the alpha characters from a string; if you have a string of TEMP0001A it will return TEMPA.

-- drop FUNCTION if it exists

IF OBJECT_ID (N'uf_AZRCRV_GetAlpha', N'FN')...

Continue Reading Ian Grieve’s Article on their blog

SQL Scripts for Microsoft Dynamics GP: Get Alpha Characters from an Alphanumeric String

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP. ‎…

Blog Syndicated with Ian Grieve’s Permission