Replacing a "Return Character" with a Space in a String [RESOLVED]

[smh295]

Hi all,

I am selecting a comment field from my database and some of the comments contain a "return character" ("||"). When I print these out, the return character forces a new line on the printout, which I do not want. How can I replace a return character in a string with a space?

Example:

Dim String1(100) As String

* Open DB
* Select Recordset
x = 0
Do while not RS.EOF
x = x + 1
String1(x) = RS(0)
Loop
* Close Recordset
* Close DB

* now I'd like to search through the array of strings and replace Returns with Spaces

Any help would be greatly appreciated.