Change one letter in line of text

[PHisaw]

Hi,

I'm not sure if this question pertains to queries, but I need answer before
proceeding to forms or reports. Let's say I have a list of part numbers

LNOKW11A
LNOKO23B
LNOKZ43C
LNOKB54O

and I want to change all the O's to zero's (0). Is there a way to find and
replace with code all the O's no matter where they are in the string. I also
have multiples of the same part number.

Any suggestions are appreciated.
Thanks,
Pam

 

[Stefan Hoffmann]

hi Pam,

and I want to change all the O's to zero's (0). Is there a way to find and
replace with code all the O's no matter where they are in the string. I also
have multiples of the same part number.

Replace([Field], "O", "0") in a query.


mfG
--> stefan <--

 

[PHisaw]

Hi Stefan,

Thanks for the quick reply. I'm not sure where I need to put the line of
code. Will you please give more direction?

Thanks for your help,
Pam

hi Pam,

and I want to change all the O's to zero's (0). Is there a way to find and
replace with code all the O's no matter where they are in the string. I also
have multiples of the same part number.

Replace([Field], "O", "0") in a query.


mfG
--> stefan <--

 

[PHisaw]

Hi Stefan,

Please disregard the first reply. I have it figured out. Thanks again for
your help.
Pam

hi Pam,

and I want to change all the O's to zero's (0). Is there a way to find and
replace with code all the O's no matter where they are in the string. I also
have multiples of the same part number.

Replace([Field], "O", "0") in a query.


mfG
--> stefan <--