Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!arclight.uoregon.edu!logbridge.uoregon.edu!news-west.eli.net!not-for-mail
Message-ID: <3DF8C99B.B5C33544@exesolutions.com>
From: damorgan <damorgan@exesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: select non-alpha
References: <at7brg$bok$1@yggdrasil.utfors.se> <3DF7D654.570AC713@exesolutions.com> <tragvu83lhf9nk54ph7qvc3djkcur07a0s@4ax.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 28
Date: Thu, 12 Dec 2002 17:38:47 GMT
NNTP-Posting-Host: 156.74.250.7
X-Complaints-To: yvonne.tracy@ci.seattle.wa.us
X-Trace: news-west.eli.net 1039714727 156.74.250.7 (Thu, 12 Dec 2002 10:38:47 MST)
NNTP-Posting-Date: Thu, 12 Dec 2002 10:38:47 MST
Organization: City of Seattle NewsReader Service
Xref: newsfeed1.easynews.com comp.databases.oracle.server:169530
X-Received-Date: Thu, 12 Dec 2002 10:45:32 MST (news.easynews.com)

John Russell wrote:

> On Thu, 12 Dec 2002 00:20:46 GMT, damorgan <damorgan@exesolutions.com>
> wrote:
>
> >Pucko wrote:
> >
> >> How to write sql /plsql to select all (rows)varchar that does NOT contain
> >> A-Z or a-z
> >>
> >> /pucko
> >
> >Work SELECT TRANSLATE(UPPER(field), '2ABCDEFGHIJKLMNOPQRSTUVWXYZ', '2')
> >
> >into your code and see if the length of the string changes.
>
> How about WHERE UPPER(field) = LOWER(field)?  If any letter that is
> affected by UPPER or LOWER is in the field (i.e. a-z, A-Z), the
> comparison will fail and the row won't match.  The question of how
> this applies to accented letters is left as an exercise for the
> reader. :-)
>
> John

Fascinating. I like it.

Dan Morgan