Hello All, How would you go about replacing a '.' without using the space ' ' in the (SRPL(0)) function. I have Imported Data in the table that looks like this:
Mr. & Mrs. A. George C. & Linda V. I want it to look like this: Mr & Mrs A --- No punctuation and no additional spaces George C & Linda V --- No punctuation and no additional spaces Following is the statement I used: Update Person set FirstName = (SRPL(FirstName,'.','',0)) Where FirstName contains '.' I receive the following error message " -Error- Argument 3 of function SRPL cannot be INTEGER. (2153)" Third argument is two single quotes. When I use the following statement the function works, however I have an additional space in the data. Third argument no has a space between the single quotes. Update Person set FirstName = (SRPL(FirstName,'.',' ',0)) Where FirstName contains '.' There is an extra space between Mr,Mrs and A I cannot have a double space between the characters. (Mr__& Mrs__ A_) Any help would be appreciated. Rich ( RINGO) Starkey ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
