[thelist] SQL Server: How Can I Convert VARCHAR to INT?

Rory,

> DTS in SQL >= 7.0 is graphical, and is simple, imho, to use, and provides
a
> great latitude of efficacy, which you seek.

    That sounds like an excellent suggestion, since transforming the data at
time of import would be the most efficient way to do it. I have never used
the GUI for DTS before (I didn't know that there was one until now!), but it
doesn't look too threatening.
    Thanks for the tip!

James Aylard