Carraige Returns

[ryand09]

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.

[rwendel]

What database are you using?

And what programming language are you using to interact with this database?

The first step is to modify the code that you are using to INSERT into this table, making it swap the '\n\r' for ' '.

Second thing might just be to just right a simple code to select all of the records (all you need is the Primary Key and the VarChar field you are having the issue with, or if you really want just the VarChar field). Load that into whatever data structure you are using to access the Record Set, then go one by one and simply change the data, and update all of the fields through a while loop that uses the same, variable update statement.