I have a shape file with points at evenly spaced intervals, the table has the following fields: Name is up to 32 characters of text. it is currently populated with an eight digit number.
Point_No is an integer field which has the same eight digit number that is in the Name field.
What I would like to do is to only label the points that have the Name field or the Point_No field which end with the number "5"
I have tried case statements, substr statements, I have tried to use the modulus with the Point_No field, but I keep getting parsing errors.