Trying to use Like to select records 1

[bdjb]

Hello,
I'm using CR9 against an Outlook global access list. In trying to find only certain people, I'm trying to use the record select formula "{Global_Address_List.Title} like '*chief*'". It gives no errors, but no output either. Without the record select, it pulls everyone just fine.

Does anyone have any suggestions?

Thanks
Bob

 

[morriskc]

Try a different wildcard character. Some environments use the % as the wildcard.

 

[bdjb]

Thanks Morriskc,
I'll give that a try

What happens if you get scared half to death twice?

 

[1chicken]

Try this:

"chief" in {Global_Address_List.Title}

Works for me every time...