String Contains

[AmauryJ]

Hello,

I would like to know if a string value contains chain "test" like this:

IIF (myvalue LIKE '%test%', "contains test", "no contains test").

But it's not work.
Have you got some idea?

Thank in advance

Amaury

[HighAley]

Hello,

What is the report language of your report?
What report engine will you use?
By default, it's C# and you should use C# expressions in the report not SQL.

Code: Select all

myvalue.Contains("test")? "contains test":"no contains test"

Thank you.

[AmauryJ]

Hello,

I use Stimulsoft Reports.Net Version 2016.3.1 with .Net Frameword v4.0.30319.
Your solution works perfectly.

Thank you very much for your answer.

[Lech Kulikowski]

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.