Re: How to do - SQL Question in Oracle

You did mean OR in the where clause, not AND, right? the character can't be both at once :)

Rachel

Matthias Gresz wrote:

> On 25 Feb 1998 00:55:02 GMT, gosar_at_bhavesh.eng.sun.com (Bhavesh Gosar) wrote:
>
> Hi,
>
> one solution may be to use the ASCI values:
>
> Select
> col-name
> from
> tab-name
> where
> (ASCII(col-name) = char(@))
> And
> (ASCII(col-name) = char(#))
> And
> (ASCII(col-name) between chr(A) and char(Z))
> ;
Received on Fri Feb 27 1998 - 00:00:00 CST