Insert 0 instead of Varchar
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! I will give that a try
refer this
http://sequelserver.blogspot.com/2007/10/selecting-numeric-values-from-column.html
aneesh