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.
PdetersAsked:
Who is Participating?
 
jamesguConnect With a Mentor Commented:
select replace(Field1, 'PPOP', 'POP' from <your_table>
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.