• Use varchar . and don't save the formatted data in the database.

    I had faced this issue , and it was a hell of a mess when a new company was acquired and we started using the data of their end. Format of phone number may differ based on the area or region or company, and you might loose flexibility.

    why varchar ? I think it's better to do string operations on varchar in sql.

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm: