Input masks allow you to display data in a particular format. However, that format isn't usually stored with the data. If you choose to store a literal character with the data, you must specify the value 0 in the input mask's second component. For instance, if you use an input mask to display a hyphen character between the two components of a phone number, you might use a mask similar to

!\(999") "000\-0000;0;_

Access Index

Main Index