strip characters in field

Access 2010

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.

1a003.jpg
10a255.jpg
3aa34.jpg

So the result would be:
1a003
10a255
3aa34



Thanks
fordraiders
LVL 3
FordraidersAsked:
Who is Participating?
 
jerryb30Connect With a Mentor Commented:
update someTable set somefield = replace(someField, ".jpg", "")
0
 
Surone1Connect With a Mentor Commented:
"update NoPic_Picture_NotAll set Material_no = replace(Material_no,'.jpg','')"

or if you donot want to modify the table and just  display the modified sting in a query use:

replace(Material_no,'.jpg','') as MatNo
0
 
FordraidersAuthor Commented:
Thanks folks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.