I have two tables which I am trying to do distance calculations on in the SQL select window of MapInfo. I have completed these calculations before so I am happy that the formula I am using is correct, however; MapInfo shows a mismatch error which I understand is to do with the colums I am trying to match not being the same format i.e. one student ID is in string (Character) and one student ID is in value (integer). I have checked this in the table structure and this is the case. I have tried to change the format in the CSV and overwrite the table but the issue remains. I have also tried adding: int(table.stud_id) to the WHERE clause and this clears the "data mis-match" error but I then get an "invalid join in WHERE clause error".
Is there away to change the format of the column in the table from character to interger in Mapinfo?