'Contains' in CR XI

[madsstiig]

Hi.
In several reports I have had the need for a 'contains' expression in a formula in Crystal Reports 11. So far I haven't found it. Is it possible?
If I have e.g. {VWALLNEW.RESCODE} can be UXZ01, UXZ10, UXZ20, UXC01, UXC10, UXC20 etc. and it can be in any order in a string. If I want all strings containing UXZ10 - what should I type in my formula?

Best regards Mads, Denmark.

 

[BettyJ]

If you want all strings containing UXZ10, you can use
[tt]"UXZ10" in {VWALLNEW.RESCODE}.[/tt]

If your data can be in lowercase,uppercase or a combination of both (like uxz10,UXZ10, uXZ10), use
[tt]"UXZ10" in uppercase({VWALLNEW.RESCODE}).[/tt]