• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

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
0
Fordraiders
Asked:
Fordraiders
2 Solutions
 
jerryb30Commented:
update someTable set somefield = replace(someField, ".jpg", "")
0
 
Surone1Commented:
"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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now