Hi all. Thanks for the replies. VARCHAR is fine. The whole reason I need to cast is because when I output the results to notepad, it wordwraps...