problems with storing data

[eranwein]

i have a tsble field which is defined as varchar(11) for storing mobile phone number.
the values should be in this format: 999-999999.

when i run an UPDATE query, it stores it with different value and without the "-".

but when i write it directly to the database with mysql-front there is no problem.

so, what should i do?

let me just say that i know about the option of seperating the two values into two different fields, but i would prefer it to be done as explained.

[shocker-z]

what code are you using?