Thank you. Would there also be a way in which I don't have to specify each Column by name?

table 1 has the columns :

m_ID : data type integer primary unique key auto increment and

description: data type nvarchar

table 2 has the columns:

m_id: data type integer no key, no...

When I try to convert to int CONVERT (INT, field1) I get the following message:

Conversion failed when converting the nvarchar value '15.500' to data type int.