Record contains wildcard char

[EB]

I have a query setup and I would like to include criteria for a field to
narrow my results. The problem is that the record contains an asterisk as
part of the value. Since asterisks are used as wildcards how can I search
for it.

I want to return values from the field that include *. How can I do this?
Thanks,
EB

Example:
ValueA_Text3_Blah*
ValueB_Test8_Blah_2
ValueA_Text2_something*

 

[KARL DEWEY]

Try this --
Find_Wild: InStr([YourField],Chr(42))
Use >0 as criteria.

 

[EB]

Works. You made my day!

Thanks,
EB

Try this --
Find_Wild: InStr([YourField],Chr(42))
Use >0 as criteria.

--
KARL DEWEY
Build a little - Test a little

I have a query setup and I would like to include criteria for a field to
narrow my results. The problem is that the record contains an asterisk as
part of the value. Since asterisks are used as wildcards how can I search
for it.

I want to return values from the field that include *. How can I do this?
Thanks,
EB

Example:
ValueA_Text3_Blah*
ValueB_Test8_Blah_2
ValueA_Text2_something*