finding # in a string

[razorking]

OK, here is wierd one:

How do I find instances in a string where there are # symbols?

For example addresses similar to; 3815 W 11TH #300

I need to find and remove all of the # things but if I say; like *#* it returns every address with a number in it...which is practically everything. I have tried quotes around the # to no avail???

 

[razorking]

Answering my own question:

Like "*[#]*"

 

[WayneRyan]

razorking,

This should work too:

Where InStr(1, [SomeField], "#") > 0

Or in the Query Grid:

Field: HasAmpersand: InStr(1, [SomeField], "#")
Criteria: True

Wayne