Search & Replace #

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I do a search & replace on #?

When I try, the search finds any number.

I just want to replace the #.

Thanks.
 
In a query you can use the replace function

Select Replace([FieldName],"#","?")

Replace the ? with the replacement
 
Thanks.

Ofer said:
In a query you can use the replace function

Select Replace([FieldName],"#","?")

Replace the ? with the replacement
--
\\// Live Long and Prosper \\//
BS"D


Linda B said:
How do I do a search & replace on #?

When I try, the search finds any number.

I just want to replace the #.

Thanks.
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

MS word Find and Replace using Regex - Help required 0
Find & replace in linked field 1
Find & Replace in linked field (2) 6
access97 to 2002 search button conversion error 1
Searching Access 1
Word Globally Changing Specific Color Highlight to Background Color 0
Substring input search 1
How do I change the default Match list in Find and Replace box? 2

Back
Top