Placeholder Negation

[npj]

Hi Everyone,

I have a search string consisting of a number of characters on the right, a number of characters on the left and the character sequence _T_ in the middle.
Normally this would then be a search string such as:

'%_T_%'

How do I negate the single placeholder '_' on both sides of the T so that it is recognised as an actual underscore?

Thanks
Peer

[ales]

Hi,

... like '%\_T\_%' escape '\'

HTH

[npj]

Thanks HTH, but no success, I'm afraid.

The entire query is:

select object_name from user_objects where object_type like 'PACKAGE' and object_name like '%\_T\_%';

This returns no results at all, but I can see loads of packages containing the '_T_' when I do the select:

select object_name from user_objects where object_type like 'PACKAGE' and object_name like '%_T_%';

This returns all objects containing the letter 'T', of course.

Bye
Peer

[jmodic]

Xou didn't read carefuly what ales has written. Your query should be

select object_name from user_objects where object_type like 'PACKAGE' and object_name like '%\_T\_%' escape '\'
;

[npj]

Hi jmodic,
You're right, of couse. It works perfectly now. Thanks to both of you.
Bye
Peer