AnsweredAssumed Answered

Remove alphanumeric character from key fields

Question asked by john9210 on Jul 20, 2014
Latest reply on Jul 22, 2014 by philmodjunk

Title

Remove alphanumeric character from key fields

Post

     FM 12. In two related tables the primary and foreign keys are automatically entered as serial numbers and have the alphanumeric character M as the beginning value. Both keys are number fields. How can I safely strip the M character from the keys in both tables with a script?

Outcomes