Showing results for 
Search instead for 
Do you mean 

Queries -- not starting with

Copper Contributor
Posts: 52
Country: USA

Queries -- not starting with

I have a custom field that I need to do a "not starting with" search on....


For example if we were looking in the field states, I would like to be search on all the states NOT starting with "New"


Any ideas?

Platinum Elite Contributor
Posts: 6,830
Country: USA

Re: Queries -- not starting with

There isn't any operator like that. While it won't work in all cases, for the example you suggested you could use the Done Not Contain operator.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer