How to remove prefix for number variables for existing records in Incident table

[Shawn33]

How to remove prefix for number variables for existing records in Incident table,
Example: usually number like INC0010043, but my requirement is to remove prefix "INC" for existing records and number should be like 0010043.  

[Ankur Bawiskar]

Hi,

why to remove prefix?

where you wish to store only the number? in some other field?

what's your business requirement?

Regards
Ankur

[Shawn33]

it is client requirement actually,
need to remove prefix INC for existing number fields incident records 

[Ankur Bawiskar]

Hi,

remove prefix from number field and replace with only number?

I don't think it's a valid business requirement.

The prefix helps to identify the numbering system for table.

Regards
Ankur

[Shawn33]

Yes

[Ankur Bawiskar · Accepted solution]

I would inform customer that this requirement should not be taken as it disturbs the OOB number maintenance + prefix logic on incident table

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur