Finding #

[baldeagle]

I'm searching through some text fields like the following:
Ann12 #1
Ann12 #2
Ann12 #3
Ann1 #12
Ann2 #14
ect...
I'm doing a like query

Like "*#*2*"

However, the # is the keyword for Date, so what do I use instead?

 

[raskew]

Hi -

The InStr() function works well in situations such as this.

Copy/paste the following query-SQL to a new query, replacing the
table & field names with your own. Run the query and see if it gives
you what you're looking for.

HTH - Bob

SELECT
    Test4Nov.MyTxtFld
FROM
   Test4Nov
WHERE
   ((InStr([MyTxtFld],"#2")>0));