Rich ( RINGO) Starkey, Try: Update Person set FirstName = (SRPL(FirstName,'. ',' ',0))
the first arugement is '. ' i.e. within the quotes that is a period and a space. You wll replace it with just a space that will take care of problem. If you have multiple spaces you could try nesting the SRPL command or you man need to build a declare cursor loop and within the loop build a series to functions to eliminate multiple spaces. Sorry but I don't have code to do that. Usually if I have this problem I export the data and use my favorite programming language REXX and it's SPACE function to format the data. -- Jim Bentley American Celiac Society [EMAIL PROTECTED] - email (973) 325-8837 voice (973) 669-8808 Fax ---- "Richard Starkey" <[EMAIL PROTECTED]> wrote: > 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/ > ================================================ 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/
