Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to do - SQL Question in Oracle
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
![]() |
![]() |