Is there a way in SQL profiler to filter by 'TextData' filter with OR conditions for multiple text criteria?

Question

I want to use TextData Like filter in the SQL Server profiler with multiple conditions to filter queries that contains any of the words. I have used OR conditions but it's not working. How can I use it? Example - %Column1% OR %Column2%

So you have not used OR, but you put "OR" in a literal string. What you need is WHERE [SOMETHING] LIKE '%somevalue%' or [SOMETHING] LIKE '%someOtherValue%' — HoneyBadger
– HoneyBadger, Commented Jan 17, 2020 at 10:52

Esat Erkec · Accepted Answer · 2020-01-17 13:12:56Z

6

The following illustration will help to solve your issue.

answered Jan 17, 2020 at 13:12

Esat Erkec

1,79411 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is there a way in SQL profiler to filter by 'TextData' filter with OR conditions for multiple text criteria?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related