Great suggestion for this example. And 40 characters was exactly right! Thanks,
Duey From: "Sami Aaron" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: SRPL to NULL Date sent: Tue, 15 Oct 2002 18:20:46 -0500 Send reply to: [EMAIL PROTECTED] > 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/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + 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/
