Thanks Sergey.
When translated into my real life situation

  execstr = "EXEC 'insert into memos (link_table,record_id,memo_name,memo_text,added_by)"
  execstr = execstr & " values ([people],"
  execstr = execstr & lcPerson_id & ","
  execstr = execstr & "[notes],"
  execstr = execstr & "CHRTRAN([" & request.form("txtNotes") & "], CHR(13) + CHR(10), []),"
  execstr = execstr & "[" & session("FullUserName") & "])'"
  response.write(execstr)
  oConn.EXECUTE(execstr)

It doesn't work. Probably the SQL handler can't deal with the CHRTRAN function. And besides, I would want to preserve the CRLF in the saved text. I could maybe preclean the request.form("txtNotes") with a VB function before putting it into the execstr but still I would want to save the original format of the text.
Any other ideas?

'''''''''''''''''''''''''''''''''''
>

>insert into mytable (memofield) values (CHRTRAN(memotext, CHR(13) + CHR(10), ""))
>

>>When using the SQL INSERT command, how do you "clean" a memo field if there are carriage returns in the memo text?
>>