Is it possible to change data type of column retrieved from one table which is in varchar to an integer while inserting to another table.
My situation is I retrieved records from a database table and store in a dataset.
From this dataset i need to insert this records to another database.
So while i do insert operation, can i cange the datatype so that it could match the data type define in my second table?