Q: sql to strip off special character ?

From: <tedchyn_at_yahoo.com>
Date: Tue, 04 Jan 2000 15:11:11 GMT
Message-ID: <84t2i3$69h$1@nnrp1.deja.com>

sir, I have a free text phone number. for example

1(933)-777-9999
933-777-9999
#933-777-9999

there is no way of predicting what special charcter may present. how do I strip off special charcter either with sql update or plsql function beside
1. using nested replace function(which requires you know the special character ahead of time) or
2. plsql block - fetch into a variable and use a for loop to take care all special charater(s).

Thanks in advance
ted chyn

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 04 2000 - 09:11:11 CST