How to retrieve the value of one field and put in 3 textboxes?

Question

How do I put a phone number into 3 text boxes when the data is stored in a single field in the database?

I want to show something like: 123-456-7890

Answer 1

string[] phoneNumber= fromDBNumber.split("-"); 

Answer 2

what language are you using?

if c# or java then string[] numbers = fromDBNumber.split("-");

then put numbers[0], [1] and [2] into the text boxes

of if you store the number as 9787545747 then you could use subString to split the number at certain points.

        string d = "9787545747";
        string g = d.Substring(0, 3);
        string f = d.Substring(4, 7);
        string h = d.Substring(5, 9);

the above is untested