I have a field with 4 digit and 5 digit numbers. I want to filter to only the 4 digit numbers and then do an update query to add a leading zero.
I think I have done this before, but none of my search criteria or pattern matching ideas are returning me the 4 digit numbers.
Thanks much!
I think I have done this before, but none of my search criteria or pattern matching ideas are returning me the 4 digit numbers.
Thanks much!