FINDING THE "#" CHAR

M

Mike

Could anyone help me ?

when used in a query what would be the best way to filter out everything
that had a # in the text field

any help would be great

regards

Mike
 
L

Les

Mike,
This will probably work for you. Create a new field in
your query like:

filterfld:instr(1,textfld,"#",1)

If # is found, filterfld will have a value of the position
where # was found.

So, in criteria, enter 0. This will only return rows
where # was not found.

Hope this helps.
 
J

John Spencer (MVP)

One method would be to use criteria of
Not Like "*[#]*"

Or possibly (UNTESTED)
Like "*[!#]*"

Or slower, add a calculated field and test it
Field: HasChar: Instr(1,[TheField] & "","#")
Criteria: 0

If you are using an ADP you will need to change the wildcard characters from *
to %
 
Top