The underscore matches a single character, unless it is escaped. Try:
select NODE_NAME from NODES where NODE_NAME like '%__SQL' escape '_'
3
solved How can I use underscores in “LIKE” conditions in Tivoli? [duplicate]
The underscore matches a single character, unless it is escaped. Try:
select NODE_NAME from NODES where NODE_NAME like '%__SQL' escape '_'
3
solved How can I use underscores in “LIKE” conditions in Tivoli? [duplicate]