Re: How to do - SQL Question in Oracle

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(_at_))
>> And
>> (ASCII(col-name) = char(#))
>> And
>> (ASCII(col-name) between chr(A) and char(Z))
>> ;
>
>
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de