Duplicate college names inserting into database because of spaces

Hello,

Try trimming out the spaces (rtrim/ltrim)and replacing (the dot) the imported into a newer table.
See sample syntax below;

- import into a temp table; table 1
- clean (with trim and replace) and write to a new table with distict keyword to remove duplicates occurring.

select distinct replace(rtrim(ltrim(var1)),'.',''), other columns INTO Permanent_Table From Table 1

Hope this helps, good luck.

Ali J