All I can't seem to remember how to use a carriage return with the replace function. Basically I need to search for a certain 1 line sentence & remove it. Using the example below it only finds the string and replaces it with a space. I need it to find the string + the carriage return and replace it with nothing.
REPLACE ( Some Field, "This is a test"," ") Thanks Kevin _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"