>That would work great with small files, but I think there is a character limit on a variable with a character data type of 255 characters right?

I don't think so. I tested with a file on my system, c:\sql.log, that is 700K, and it worked. Pretty quick too.