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/
