Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to do - SQL Question in Oracle

Re: How to do - SQL Question in Oracle

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/02/27
Message-ID: <6d6o0s$o2r$2@news01.btx.dtag.de>#1/1

On Fri, 27 Feb 1998 09:00:08 -0500, Rachel Carmichael <rachel.carmichael_at_citicorp.com> wrote: Of course!

>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))
>> ;
>
>
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de
Received on Fri Feb 27 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US