I am inserting data from one table to another.
The column in table 1 is varchar
The column in table 2 is int
If the data in table is not a number, for example "E"
how can I insert 0 instead?
Most of the data is numbers, but I have come across some letters and would just like to insert zero.