I want to right click filter a column to exclude all items that have a period in them.
A adgorn Jan 20, 2009 #1 I want to right click filter a column to exclude all items that have a period in them.
A adgorn Jan 20, 2009 #2 Figured it out from a previous answer by Mr. Vinson. Use Not Like *[.]* Thanks!
P pietlinden Jan 20, 2009 #3 I want to right click filter a column to exclude all items that have a period in them. Click to expand... SELECT Patient.FirstName, Patient.LastName FROM Patient WHERE (((Patient.LastName) NOT Like "*.*"));
I want to right click filter a column to exclude all items that have a period in them. Click to expand... SELECT Patient.FirstName, Patient.LastName FROM Patient WHERE (((Patient.LastName) NOT Like "*.*"));
