How can I use underscores in "LIKE" conditions in Tivoli?

Question

I can't properly use underscores in the LIKE part when I use Tivoli databases.

I connected to a Tivoli database with AQT and just run this query;

select NODE_NAME from NODES where NODE_NAME like '%_SQL'

This query gets as result;

AKHEDEFSRV_SQL
AKHEDEF_SQL
AKLSFS_SQLPAKL1_SQL
AKLSFS_SQLPAKL2_SQL

But also gets

AKLSPRODSQL
AKLSTESTSQL

It looks to me as if Tivoli ignores the underscore in the LIKE part of the query. Anyone has an idea?

Geoff · Accepted Answer · 2013-05-10T13:13:23.647

3

The underscore matches a single character, unless it is escaped. Try:

select NODE_NAME from NODES where NODE_NAME like '%__SQL' escape '_'

edited May 10 '13 at 13:13

answered May 10 '13 at 12:46

Geoff

Which RDBMS are you using? – Geoff May 10 '13 at 12:56
2

Try the double underscore in my edit... – Geoff May 10 '13 at 13:15
Yep, that's right. The weird part is there is no even document to use this underscore in `LIKE` part of the query, maybe at least I can't find online.. Thanks! – Soner Gönül May 10 '13 at 13:22

1 Answers1