Duey - I don't know of any way to do that with the SRPL but you can try this -
Not knowing the width of your field, Mailname, this example assumes it's 40 characters. UPDATE sights SET mailname = (SGET(mailname,40,4)) WHERE mailname LIKE 'MR. %' Sami ----------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 http://www.softwaremgmt.com ----- Original Message ----- From: "Duey Heffelfinger" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 5:53 PM Subject: SRPL to NULL > Good afternoon, > > I would like to replace all occurances of 'Mr.' with NULL in a > mailname field. Here's what I've tried: > > UPDATE sights SET mailname = (SRPL(mailname,'Mr.','',0)) > UPDATE sights SET mailname = (SRPL(mailname,'Mr.',NULL,0)) > > Both give me this error message: -ERROR- Argument 3 of function SRPL > cannot be INTEGER. > > I've SET ZERO both ON and OFF with the same results. > > Is this an improper use of the string replacement? Is there a way to > do this? > > Duey++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ++++ > + Duey Heffelfinger, Director of Computer Services > + > + E-mail: [EMAIL PROTECTED] Dana College > + > + Phone : 402-426-7289 2848 College Drive > + > + Blair, Nebraska 68008 > + > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > + If you can dream it, it can come true! > + > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > ================================================ > 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/
