Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select non-alpha
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.
Daniel Morgan Received on Wed Dec 11 2002 - 18:20:46 CST