UNKNOWN --************************************** -- Name: Remove Carriage Returns and Line Feeds -- Description:This code will help you remove carriage returns and line feeds from you Oracle .db. -- By: Mike J Anderson -- -- -- Inputs:Example: UPDATE constituent set First_Name = replace(replace(First_Name, CHR(10)), CHR(13)); -- -- Returns:This returns the First_Name field w/o any carriage returns or line feeds. :) -- --Assumes:None -- --Side Effects:No known side effects. --This code is copyrighted and has limited warranties. --Please see http://www.Planet-Source-Code.com/xq/ASP/txtCodeId.335/lngWId.5/qx/vb/scripts/ShowCode.htm --for details. --************************************** UPDATE constituent set First_Name = replace(replace(First_Name, CHR(10)), CHR(13));