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?
>
>

>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