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.
Troy,
If the format is always the same, then:
UPDATE TableName SET PhoneNo = ((SGET(PhoneNo,3,1))+(SGET(PhoneNo,4,5)))
Have Fun!
Very Best R:egards,
Razzak.
