Here is my problem.
I am importing information from a text file to a MYSQL database.
In this text file there is a field that holds prices that is formatted #,###,###
Since it is this way, I cannot make the field a number field with out cutting
off everything after the first coma. I am trying to perform a search on this field
but it does not come out right since it is a char field instead of a number field.
How do I convert this field into a number field without losing most of the data?
I am importing information from a text file to a MYSQL database.
In this text file there is a field that holds prices that is formatted #,###,###
Since it is this way, I cannot make the field a number field with out cutting
off everything after the first coma. I am trying to perform a search on this field
but it does not come out right since it is a char field instead of a number field.
How do I convert this field into a number field without losing most of the data?