Re: SQL Query

From: <michael_bialik_at_my-deja.com>
Date: Thu, 24 Feb 2000 19:36:25 GMT
Message-ID: <89417p$6rj$1@nnrp1.deja.com>

Hi.

That's supposed to work:

SELECT * FROM tab_name
WHERE TRANSLATE ( field_name,' 0123456789','99999999999' ) =

RPAD ( '9', LENGTH(field_name), '9');

FULL table scan will be used.
Try using function-based index if performance is an issue.

HTH. Michael.

In article <89393t$5231_at_ppd00021.deutschepost.de>, "Birgit Kemnitz" <B.Kemnitz_at_deutschepost.de> wrote:
> Hello,
> we are working with a database in oracle 8i.
> In a field which is defined as varchar2 are values like '01004578' and
> values with an alphabetical
> sign in it like '0100K124'. Is there a way to select all fields which
have
> an alphabetical sign in it?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 24 2000 - 13:36:25 CST