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

this question has answer here:

• use underscore character in wild card charecter of query gives me table result 4 answers

i can't use underscores in like part when use tivoli databases.

i connected tivoli database aqt , run query;

select node_name nodes node_name '%_sql' 

this query gets result;

akhedefsrv_sql akhedef_sql aklsfs_sqlpakl1_sql aklsfs_sqlpakl2_sql 

but gets

aklsprodsql aklstestsql 

it looks me if tivoli ignores underscore in like part of query. has idea?

the underscore matches single character, unless escaped. try:

select node_name nodes node_name '%__sql' escape '_'