Re: SQL Question
From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Wed, 12 Aug 1998 23:00:00 +0200
Message-ID: <6qsvna$ck7$1_at_newton.a2000.nl>
Date: Wed, 12 Aug 1998 23:00:00 +0200
Message-ID: <6qsvna$ck7$1_at_newton.a2000.nl>
Joep,
select telephone
from my_table
where length( translate( telephone, '# -0123456789', '#' ) ) > 0;
The #-sign can be just anything. It is replaced by yet another #-sign, so nothing changes really. For the space, dash and digits no replacement is given, so they are deleted. All other charachters are not affected.
Arjan. Received on Wed Aug 12 1998 - 23:00:00 CEST