Search results

Format of field The field is currently a text field and can have absolutely anything in it!

Hi I am trying to run some queries on a large customer file that has very poor data - particularly in the contact number fields. If there are more than six "1"s, "9"s, or "0"s in the number, then we are planning to treat it as an invalid number and replace it with a null. Any ideas about how...