An input mask can be created to allow a user to enter a Social Security number as 831867180, but store it in the table as 831-86-7180.

Question

Quizplus · Accepted Answer

An input mask can be used to format the user's input to match the desired pattern, in this case, allowing the user to enter the Social Security number without dashes. The database can store the value with the dashes included, without impacting the user's input.

An Input Mask Can Be Created to Allow a User