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_at_engnews2.Eng.Sun.COM>#1/1
Date: 1998/02/25
Message-ID: <6cvq56$nqh$1_at_engnews2.Eng.Sun.COM>#1/1
Hi,
[Quoted] I want to search a column of a table which has first character as one of this - _at_ , # 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 '[_at_#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 CET