Query for # character not working

[Dawn]

To prepare data for an upload, we need to query for illegal characters such
as & ? \ within descriptions and other billing info. This has been successful
for a number of years with query criteria such as Like "*&*" or Like "*/*".
The query no longer works with the additional character of the # sign (Like
"*#*"). Now all records out of a group of 5,000+ match the criteria. I am
unable to find any resources that explain issues with the # character.

Thanks in advance for any workarounds or insights.

 

[Krzysztof Naworyta]

Juzer Dawn <[email protected]> napisaÅ‚

| To prepare data for an upload, we need to query for illegal characters
| such as & ? \ within descriptions and other billing info. This has been
| successful for a number of years with query criteria such as Like "*&*"
| or Like "*/*". The query no longer works with the additional character
| of the # sign (Like "*#*"). Now all records out of a group of 5,000+
| match the criteria. I am unable to find any resources that explain
| issues with the # character.
|
| Thanks in advance for any workarounds or insights.


Did you read about wildcards inside a Like operator?
?, *, #, [, ], ...
If you want to find a text that includes "?" you need to type as follows:

Where field1 Like "*[?]*"

The same if you use any other wildcards:

Where field1 Like "*[#]*"

# is a widcard for any digit.

 

[Dawn]

KN,
Wonderful! I'm familiar with the other wildcards but not the # sign. Your
answer corrected my problem with the queries.

Thank you!