Locating the string "#" in a field

  • Thread starter Thread starter tonyl
  • Start date Start date
T

tonyl

I'm analysing a table using Access 2002 filters and need to find
instances of the string "#" within a text field.

How do I do that as "#" has special meaning?

Any pointers to links that give the answer welcomed as # or hash
bring up a lot non-related issues.


Many thanks.

TonyL
 
Enclose the special character in square brackets - ie:

SELECT * FROM YourTable WHERE Field LIKE '*[#]*'
 
Perfect thanks Susan.

TonyL

Enclose the special character in square brackets - ie:

SELECT * FROM YourTable WHERE Field LIKE '*[#]*'

--
hth,
SusanV


I'm analysing a table using Access 2002 filters and need to find
instances of the string "#" within a text field.

How do I do that as "#" has special meaning?

Any pointers to links that give the answer welcomed as # or hash
bring up a lot non-related issues.


Many thanks.

TonyL
Click to expand...
Click to expand...
 

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

extract 3 numbers from a string 0
In String - Urgent Request 5
Number of Occurrences of a String Value within a String 4
Separating strings in a field to separate fields 2
Multiple forms in query string 1
how to put in sql code 2
Finding the value in a string 2
Using strings to filter database 4

Back
Top