Is it possible to put wildcards in front of and in back of a text test?

I am doing a test on a field to allow a number used in an associated field.

I set up recognize wildcards in fields, but is this a valid check for example:

$'Ship Definition Tab'.A50 = "*Launcher*" (Since the text does not allow in this field, I put an asterisk in front of and behind the word Launcher and inside the quotes)

Sample text is as follows:
Missile Launcher - Micro
Missile Launcher - Small
Missile Launcher - Medium

There are other field values that do not have “Launcher” in them.

If not this test, what is the best means of testing if this text is in the field?

=ISNUMBER(SEARCH("launcher";$'Ship Definition Tab'.A50))

2 Likes

THANK YOU…works great…

1 Like