Re: Allow Alphabetic Chars Only?
From: <stormbox_at_my-deja.com>
Date: 2000/07/07
Message-ID: <8k4u4k$qi0$1_at_nnrp1.deja.com>#1/1
Hello World
Date: 2000/07/07
Message-ID: <8k4u4k$qi0$1_at_nnrp1.deja.com>#1/1
In the Forms validation or DB trigger use the translate and replace functions to remove the numeric characters, eg
SQL> select replace(translate('He5l6lo World99', 2 '1234567890','9999999999'),'9','') 3 from dual;
REPLACE(TRA
Hello World
Hope this is of some help,
David
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Jul 07 2000 - 00:00:00 CEST