I had a customer ask me this morning if it was possible to change the number prefix for records in the Change Request table. Specifically, they wanted to change the prefix from the default 'CHG' to 'RFC'. The answer to this question is 'Yes', but there are a couple of things you need to do and be careful about...especially if you're changing the prefix in a table that has existing records using the prefix. In this post, I'll explain how you can adjust the number prefix of a table using the Number Maintenance module. I'll also show how you can use a script to adjust the number prefix on existing records.
http://www.servicenowguru.com/scripting/changing-number-prefix-existing-records/
