I have a table called "NoPic_Picture_NotAll"
Field called "Material_no" text
In this field I have a list of jpg names...(no actaual pics)
What I need:
I need to delete the ".JPG" FROM Every record in this field.
So the result would be: