Grid Mask

I have a varchar field and I want to have the user enter 123-123-1234 for the phone number. I would prefer them not to have to enter the dashes for the phone number.
I put a grid mask on the form of 999-999-9999 and that seems to work fine, except when I do the same on my grid it looks this this
123-123-1234999-999-9999
which of course is not correct.
If I leave the Grid Mask blank I get
1231231234
which is not what I want.

Using most current version of SC.

Can someone tell me what I’m doing wrong??

I would actually prefer the actual field saved in the database to be in the format 123-123-1234 so that anytime I display it, I wouldn’t have to worry, but was not sure how to do that.

Alan

I ended up changing the 999-999-9999 to ###-###-#### and I think it’s going to work better.