Hello Guys,

I have a question here regarding the filter available in Crystal. I was wondering if there is a way of achieving something similar to "LIKE" used in SQL?

I have a long string which consists of non-alphanumeric characters and numeric characters. Something like this: ####$$$%4789%%%#$#$#

What I need to do is achieve a filter equivalent to:

"where string is Like/containing 4789:

Basically, look for certain numeric characters in a long string something like mentioned above. Please let me know if there is way to achieve the aforementioned.

Any help is highly appreciated.

Thanks,

you can also use the instring option

Hello,

Edited by Jyri - 24 Feb 2010 at 11:53pm