calculation perform: find a text among a long text field
sorry this is a stupid question, I am sure! But I do not find the proper function to do this.
I have a calculation that says: if I write a Name in the Name field in the New Clients table, check the Old Clients table if that name already exists. It does work if the name I put in is exactly the same but what if there is a typo or there is also a middle name or whatever other case???? I need file maker to tell me if that name might already exist in the Old Clients table so I can go there and check to see if it is really the same client.