Storing data with format

[Al Kramer]

I have a database built on imported external files. The phone numbers in these files were stored with formatting. That is the number is stored as 999-999-9999.
I know that best practice is to store raw data & format it for display however, if i start to do that now I will have the numbers stored differently. I'm thinking that this will lead to problems down the road. Any ideas? How can I store new numbers with formatting?

Thanx

Al

 

[cheekybuddha]

Why are you starting a new thread for this?

Was your question not answered here?

 

[The_Doc_Man]

Al, you have asked this same question already.

Data format problem

I have created an access database by importing external data. The data i have imported has the phone field stored with its format ie 999-999-9999. I know this is not best practice but if i store my new data raw I will have the data store in differnt ways. I'm thinking this will cause future...

www.access-programmers.co.uk

Please don't repeat posts. Shopping around for another answer isn't going to work here.