I have a field named ProductID, as text.
As is a text, when scans a barcode, it generates a additional space. To avoid this, the field ProductID, should be
But the fear I have, whats happen if a change the field from text to number, when in a database containing 3,000 records,
it keeps, 2700 numbers and 300 texts with letters. Do I can lost something if I do this?