Changing existing Request ID field value format when the Request ID does not have a prefix

The following examples assume that the table is named T43 and that the field size is 8 characters. The 8 represents the number of characters to keep, starting from the right side of C1. C1 is originally 15 characters long. Make sure that the number of characters in the second parameter in the RIGHT function is equal to the new size of the C1 field and that the sum of the two numeric values in the SUBSTR function is 16 (1 greater than the original length of C1 ).

Oracle database scenarios

To add a prefix to the T schemaID table, use the following syntax:
update T43 set C1 = substr(C1,8,8);

To add a prefix to the B schemaID table, use the following syntax:
update B43 set C1 = substr(C1,8,8);

For the H schemaID table, use the following syntax:
update H43 set entryId = substr(entryId,8,8);

For the B schemaIDC fieldID tables, use the following syntax:
update B43C536870924 set entryId = substr(entryId,8,8);

For the T schemaID C fieldID tables, use the following syntax:
update T43C536870924 set entryId = substr(entryId,8,8);

For more information about the SUBSTR function, see SUBSTR.

Microsoft SQL Server scenarios

To add a prefix to the T schemaID table, use the following syntax:
update T43 set C1 = RIGHT(C1, 8)

To add a prefix to the B schemaID table, use the following syntax:
update B43 set C1 = RIGHT(C1, 8)

For the H schemaID table, use the following syntax:
update H43 set entryId = RIGHT(entryId, 8)

For the B schemaIDC fieldID tables, use the following syntax:
update B43C536870924 set entryId = RIGHT (entryId, 8)