Carriage return to </ br>

[Hightower]

I'm just tinkering about with something in ASP and was wondering if there was a simple way to do this:

A user types into a text box a couple of paragraphs (which are separated by some carriage returns). The user then submits it to a database but the carriage returns are gone.

I need a way to tell it for each carriage return put a <br /> in place.

I'm sure there is a simple solution and someone will sort me out

[webman]

replace(text,VbCrLf,"<br>")

[Hightower]

Cheers Craig - as soon as you posted it it jogged my memory.... Been a while.

[powdarrmonkey]

Presumably you're going to present it back in HTML at some point; you could also store it literally and use <pre></pre> around it.