OraFAQ Forum: SQL & PL/SQL » select non-alpha

Home » SQL & PL/SQL » SQL & PL/SQL » select non-alpha

Wed, 11 December 2002 05:25

Anna N
Messages: 1
Registered: December 2002

Junior Member

How to write sql /plsql to select all (rows)varchar that does NOT contain
A-Z or a-z

/Anna

Wed, 11 December 2002 11:15

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

One method that works well if you just have letters and numbers (no special characters like !, @, #, etc.:

select *
  from t
 where lower(c) = upper(c);

Previous Topic:	Transaction handling through Front End..
Next Topic:	Compare varchar2

Goto Forum:

]

Current Time: Wed May 15 05:38:11 CDT 2024