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