Re: How to do - SQL Question in Oracle

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