I have a table that has a list of numbers. The data type of this column is TEXT, and some of the rows (numbers) contain leading zero. e.g. 012345678, 023456789... This column is going to be linked to a column in a link table which is also contains the same information (numbers) but in NUMBER data type, but the numbers are without leading zero.e.g. 12345678, 23456789...
In order for me to link the 2 tables, I changed the data type of the first table from TEXT to NUMBER, as a result the leading zeros are gone.
How can I keep the leading zero?
How do I retain leading zero in number
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar