FINDING THE "#" CHAR

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
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.
 
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 %
 
Back
Top