Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: Replace function and the character "#"

    I've tried to no effect to do a mass replacement in a database of addresses to replace "#" with "STE" or "UNIT". Searching for "#" just retrieves any numeric character, whether I use "" or not.

    Is there a separate syntax for this that can work around the symbology problem? It would really help since the Post Office prefers that # be replaced with something else, preferably STE.

  2. #2
    Join Date
    Jun 2004
    Have you tried 'Like "#"'?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts