<< Use a cursor and WRITE. You are likely going to have to think around the crlf and lineends, maybe massage the data with SRPL before WRITEing. >>
Yeesh. I figured out a short term work-around by creating a UNIONed view in which a dummy select at the head of the union forces a cast of the VARCHARs to NOTE (interestingly, this doesn't work if you just select (VarCharCol), you have to use the UNION syntax). They can use the view in the same way as the original table. It's slow, but it works. When I get a chance, I'll convert the VARCHAR back to NOTE in the table. -- Larry
