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"

Reply via email to