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 -> How to do - SQL Question in Oracle

How to do - SQL Question in Oracle

From: Bhavesh Gosar <gosar_at_bhavesh.eng.sun.com>
Date: 1998/02/25
Message-ID: <6cvq56$nqh$1@engnews2.Eng.Sun.COM>#1/1

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 Received on Wed Feb 25 1998 - 00:00:00 CST

Original text of this message

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