Using like and the "_" 2

[jetec]

SQL> SELECT TNAME FROM TAB WHERE TNAME LIKE 'TEST_%';

TNAME
------------------------------
TEST2
TESTA
TESTB
TESTING123
TESTINGA
TESTJE
TEST_12_JE
TEST_13_JE
TEST_PROCESSES
TEST_TAB

This is pulling all of these..i only want it to pull the following:

TEST_12_JE
TEST_13_JE
TEST_PROCESSES
TEST_TAB

Any ideas?

 

[Thargy]

jetec,

SELECT tname
  FROM tab
 WHERE SUBSTR(tname,1,5) = 'TEST_';

ought to do what you want.

Regards

Tharg

Grinding away at things Oracular

 

[SantaMufasa]

Jetec,

You can produce the results that you want by using (and declaring) an excape character of your choosing. In the example, below, I have used the octothorpe ("#", aka "pound-sign") character to satisfy your need (using your original data):

select * from tab where tname like 'TEST#_%' escape '#';

TNAME
--------------
TEST_12_JE
TEST_13_JE
TEST_PROCESSES
TEST_TAB

Let us know your thoughts.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[jetec]

Thanks Mufasa!!!

 

[SantaMufasa]

...excape character...

I can be such a loser sometimes...Thank you, Jetec, for the Purple Star, but that type of inexcusable typographical/grammatical mistake means I don't deserver the reward.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[sedj]

Hehehe :

deserver the reward

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[SantaMufasa]

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]