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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fIND AND REPLACE?? 1
Sorting, replacing data 1
replace 5
Find and replace ? 9
Find - replace automatic 7
Character Replacement 5
Replace values with a foreign key. 1
Replace command in word 1

Back
Top