Home Forums SQL Server 7,2000 T-SQL Wholsesale conversion of char to varchar? RE: Wholsesale conversion of char to varchar?

  • Great help, Thanks!

    I think I can see how to generate the similar code for the ALTER TABLE - I know the xtype to search for is '175' and replace with '167'.

    Just hadn't thought of the idea of generating update commands via a literal and variable string concatenation...clever!

    Thanks again!

    J.C.Michael

    "You can never have too much reverb"


    J.C.Michael

    "You can never have too much reverb"