chr1stoper1
07-13-2015, 11:33 AM
Hi I wonder if anyone can help me with a problem I have with some data. Is it possible to convert numbers in a one field to something else.I have received the data from someone else who uses a different type of data base.
I have a lot of data that has machines identified as numbers .For example tractor is 1 and all 1sin that field are tractor and 2s are trailers ect.
I would like to get rid of the numbers and convert them to the machines .I want to be able to do queries on the machines not numbers.
I hope this makes some kind of sence.
Thanks for reading this
I have a lot of data that has machines identified as numbers .For example tractor is 1 and all 1sin that field are tractor and 2s are trailers ect.
I would like to get rid of the numbers and convert them to the machines .I want to be able to do queries on the machines not numbers.
I hope this makes some kind of sence.
Thanks for reading this