Can this type of find be done?

[ibiubu]

I have a field that has job numbers in it. Is there a way to do a find that will do 2 things...

1) find any record where the field is empty

2) also find any records where the field contains the word "Blank"

I know how to do each of these on their own, but is there a way to combine the 2 so that only the records show that match both these results?

LR

[Ocean West]

Create a calculation:

isEmpty(JobNumber) or JobNumber = "Blank"

This will result in a true or 1 if either condition is ture and 0 if both fail.

Do a search on this new field look for 1.

[ibiubu]

OK, makes sense. But is there a way to slightly alter the way this works...

isEmpty(JobNumber) or JobNumber = "Blank"

Looks for an exact match of Blank. Can it look to see if the field contains the word blank in any variation, such as Blank 1, Blank 22, ect.

LR

[Vaughan]

Sure, just keep adding "or JobNumber = "Blank-whatever" for each permutaion you are likely to get. Or use the PatternCount(JobNumber, "Blank") > 0 function which will look for the string "Blank" and return a positive -- but only if "Blank" is not used legitimately in any job number.

Of course it's easier to stop people from entering an infinite variety of text strings into the database in the first place, and exercise some control of what goes into the fields.