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: <6d5sp0$c1n$3@news00.btx.dtag.de>#1/1

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

>Hi,
>
>I want to search a column of a table which
>has first character as one of this - @ , # or A-Z
>
>How do i search in Oracle using one SQL statment...
>Something like ...
>
>Select col-name from tab-name where
> col-name like '[@#A-Z]%';
>
>(The above does not work in Oracle SQL)
>
>Any workArounds...??
>Is it possible to do in Oracle...??
>
>TIA,
>Bhavesh Gosar
>
>
>

--

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