Find string function help

This is the function I am using in excel.

=ISERR(FIND("NOT FOUND",[@address_check]))

What this does is if it finds "NOT FOUND" in my field called address_check then it returns a "TRUE" else it returns "FALSE".

I am trying to figure how to code this for Crystal Reports?  
What function checks for the string "NOT FOUND" in a field?
What if the field contains more than "NOT FOUND" in the string and all I want it to find is the "NOT FOUND" part of the string?
j2911Asked:
Who is Participating?
 
mlmccCommented:
Try using

    InStr({@address_check},"Not Found") > 0

mlmcc
0
 
j2911Author Commented:
Thanks.

Can you explain what does the >0 do in this statement?
0
 
mlmccCommented:
InStr returns the location of the search text.  If it is 0 then the text was not found

mlmcc
0
 
j2911Author Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.