Find a # character in access table

  • Thread starter Thread starter Jerry C
  • Start date Start date
J

Jerry C

I have a Parts table and people have used the # sign in some of the part
numbers.
Example: # 12 Wire
How can I do a find on the part number field to find and replace the # sign?
When I do a find in the column using the # sign it is interpeted as finding
a number.
 
I have a Parts table and people have used the # sign in some of the part
numbers.
Example: # 12 Wire
How can I do a find on the part number field to find and replace the # sign?
When I do a find in the column using the # sign it is interpeted as finding
a number.
Click to expand...

Surround the # with square brackets:
[#]
 
Back
Top