I got a VarChar field which can take up to 1000 characters. The problem is that users are putting in carraige returns into their text. When I down load the data from a web page (using Cold Fusion) to excel, the carraige return is taking the text on to a new line. Is there a way I can run an update query or some how eliminate the carraige returns in the dB field.

Thankd in advance.