How to replace ? with other data

  • Thread starter Thread starter coachep
  • Start date Start date
C

coachep

I have a column in a table where I need to replace every instance of "?" with
a 6. However, when I do a search for "?" it just finds the next character in
the column. I guess that the question mark must act like a wild card. Does
anyone have any suggestions?
 
Search for [?] .

That works for any special character that might also be used as a wildcard.
 
Hi,
try the replace function in an update query:

=Replace([YourField],"?","6")

HTH
Good luck
 
Thank you so much. The function worked and saved me a ton of time trying to
figure this out.

Scott
 
Back
Top