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

add a character to an exisitng word in an Access Query

I have an Access query and one of the fields has the letters PPOP in it.  Example

Field1
PPOP
PPOP
LIGHT
LONG
PPOP

Just for this query I want it to show
POP
POP
LIGHT
LONG
POP

It can not be changed in the database because it is need at other times the other way.
0
Pdeters
Asked:
Pdeters
1 Solution
 
jamesguCommented:
select replace(Field1, 'PPOP', 'POP' from <your_table>
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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