How do I increase the field length of the mobile phone field from 15 to 25 character in the Users table?
- You want to increase the field length from 15 to 25 characters for the Mobile Phone field in the Users table
Here is what you need to do::
The command you follow is ALTER TABLE table_name ALTER COLUMN column_name datatype;
An example for the mobilephone field would be:
ALTER TABLE Users ALTER COLUMN Mobilephone nvarchar(25).
- You need to petition ATLAS Support to update the mobilephone field because the next time you upgrade, your phone numbers will be truncated back to 15 characters.