I have created loops that go through the characters and build a new string not including the ones I don't want. It woudn't be hard to create your own new function as a stored procedure.
An enhancement request I have made repeatedly for years is to allow a null string as the third argument of the SRPL function. Or, alternatively, it would be great to have new functions that were the equivalent of the R:Tango <@OMIT> and <@KEEP> tags. I hear that enhancement requests are being considered for RB 7.1 or later. Bill On Fri, 20 Jun 2003 08:14:25 -0600, Troy Sosamon wrote: >Has anyone figured out how to use SRPL to not only remove a character, but >the spact too. >I need a function that will strip the dashes out of phone numbers. >123-4567 needs to come back 1234567. >I can loop through and process on character at a time, but I would really >like to be able to get the results in a select w/o having to do that. >Thanks, >Troy
