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

From: Ed and Susan Crotty <boing_at_megsinet.net>
Date: Tue, 12 Jan 1999 22:58:15 -0600
Message-ID: <369C27E7.6DC3C063@megsinet.net>

use the translate function to convert 0-9 to one character ('0') and a-z and A-Z to another character ('X')

translate(mycol,'0123456789abcdefg.......XYZ','0000000000XXXXXXX.....XXXXX')

then an instr function around this searching for the 'X'

where instr
(translate(mycol,'0123456789abcdefg.......XYZ','0000000000XXXXXXX.....XXXXX'),'X')
> 0

will give you the answer you desire.

Ed Crotty
BALR Corporation - "Chicago's Finest"
Oak Brook, IL
630-575-8200

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 Tue Jan 12 1999 - 22:58:15 CST