In my case TEXT_MATCH(name,'Bob') returns 20 records, and TEXT_MATCH(name,'B*') returns 30, but using OR I get one or the other.