Guys, That worked great.
Thanks Steve -----Original Message----- From: Ramsour Mike [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:56 PM To: [EMAIL PROTECTED] Subject: [RBASE-L] - RE: Text Editing Steve: I would suggest looking at the SRPL SuperMath function. Look up the syntax in the help section. This function looks for a string of characters inside another string and if found replaces it with another string of characters. Your command would look something like this using an example from my database: UPDATE custmast SET custname = (SRPL(custname,'STEEL','ALUMINUM',1)) WHERE custname CONTAINS 'STEEL' This command replaces every occurrence of 'STEEL' with 'ALUMINUM' for those customers that have 'STEEL' in their name. Give it a try and let us know how it turns out. Mike Ramsour -----Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:26 PM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Text Editing I have a word spelled incorrectly in a field in many rows in a table. Is there a way to find and replace that word in the rows and leave the rest of the rows and field contents the same? Thanks Steve Fogelson Internet Commerce Solutions
