> insert into Table (ColumnA, ColumnB)
> select cast(ColumnA as BIGINT), ColumnB from ExternalTable
>
> Numbers must be converted, varchars shouldn't be neccessary to convert.
>
> HTH,
> Set

Sorry, I spoke too quickly without thinking, Alan is right, you don't
have to convert anything.

Set