Answer to Question #318594 in Databases | SQL | Oracle | MS Access for Memo

Question

Of the data type text, number, or yes/no which would be the appropriate for a phone number field that need to store data in the format [phone]? Explain your answer.

Answer 1

Text is better to store the number in the given format. Reason being we need hyphen and dash to be incorporated.