Hello everyone, I am having a hard time figuring out how to build this query. What I have is I have a field with this data in the field REASSIGN: WO# - Reassigned from  to [John Smith] and other data in the field like this MODIFY: WO# - copier. What I would like to do is build a query that will pull all the records that have the REASSIGN: in the begining of the field. I tried a like but that didn't work. Any ideas on how to do it? Thanks :)
PS Reassigned from  to [John Smith] This field will be different for each record. Thanks again.