I'm using asp classic, vbscript and sql server.

The most condensed way to pose the question is I need to be able to perform a LineFeed and CarriageReturn in both a (Window's program written in VB) VB textarea and an HTML textarea using text type data from a sql server field. And I need to use an HTML textarea to input the new string if it matters.

The field in question is a notes field and it includes a date such as:

Date: NoteStringWhatEver

Here's the tricky part...

When a new note is created, the note is concatenated to the beginning of the previous note..

8-31-06: Note
7-31-06: Another Note

I need to store this string in such a way in a sql server field that both vb and the textarea will be able to display it as:

8-1-06: Note
7-31-06: Another Note

and not...

8-1-06: Note 7-31-06: Another Note

and not...

8-1-06: Note#10;#13;7-31-06: Another Note

and not...

8-1-06:Note<br>7-31-06:Another Note

I have no control whatsoever over the VB Window's program nor the sql table. It would be great to have a separate notes table but it's not possible.

Any help would be greatly appreciated.

Jason

Have you tried using vbCRLF?

"The one language all programmers understand is profanity."

That got it. Thanks.

glad it worked.

"The one language all programmers understand is profanity."