Formula Editor Searching for a wildcard in "in statemen

system · July 7, 2011, 5:04pm

can you do this in Crystal Reports?
{table_name.DESCRIPTION} in [“ADDRESS*”, “NAME”, “ZIPCODE”]

I want to use the asterick as a wild card, as you can in a Like statement.

Thanks.

bucketOfChicken (BOB member since 2010-11-10)

system · July 7, 2011, 9:04pm

Yes, sorta. use LIKE instead of IN.

kevlray (BOB member since 2010-06-23)

system · July 13, 2011, 8:55am

do like this
{table_name.DESCRIPTION} LIKE “ADDRESS*” OR

{table_name.DESCRIPTION} in [“NAME”, “ZIPCODE”]

karthicse (BOB member since 2006-11-08)