Locating the string "#" in a field

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
 
S

SusanV

Enclose the special character in square brackets - ie:

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

tonyl

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...
 
Top