I need to preface this question by stating that I know what the acronym SQL stands for, but that's about the extent of my SQL knowledge at this time (I'm trying though!).
I am the administrator for a Microsoft Axapta 2012 ERP system, which uses SQL 2008 for its databases.
It appears that for the past few years, there has been inconsistencies with how our engineers have formatted the names of the parts that we manufacture. Many use all capital letters, while some use first letter capital only, and one 'lone wolf' used all lower case.
The CEO of our company noticed this and wants all 14,000+ parts changed to first letter capitalized, remaining letters lower case. In some instances, the field where the part number is listed begins with a special character (hyphen or asterisk most of the time) or a number... in these instances, those characters would have to be ignored, and the first alpha character would need to be capitalized.
Is this as complicated as it sounds? If it is, is there anyone out there who might be able to provide some assistance?
Thank you in advance.