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

insert into mytable (memofield) values (memotext)

I am running this from an ASP page and it crashes if there are CRLF in the memotext.

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 & "[" & request.form("txtNotes") & "],"
execstr = execstr & "[" & session("FullUserName") & "])'"
response.write(execstr)
oConn.EXECUTE(execstr)

Thanks