Re: how to find alphanumeric's in a column?

From: Michael Ringbo <mri_at_dde-nospam.dk>
Date: Wed, 13 Jan 1999 09:27:54 +0100
Message-ID: <369C590A.BA413266@dde-nospam.dk>

Hi,

As a possibility you could try the replace standardfunction and replace all the unwanted characters with ''. Like this:

select replace(replace('A12B12C1212','1',''),'2','') from dual;

REPLACE(REPLACE('A12B12C1212','1',''),'2','')

ABC Regards,

Michael Ringbo

Sajnish Gupta wrote:

> Can anyone tell me of a Oracle function, that finds alphanumeric characters
> in a column.
> For e.g. if i want to find that a column called field1 (mainly consisting of
> numbers) has any A through Z characters, how will i find it.
> thanks
> SG
Received on Wed Jan 13 1999 - 02:27:54 CST