Symptom
How to search a memo field in Crystal Reports formula for a case sensitive string
Resolution
Use Instr function to search for the number representing the position of a string.
Syntax:
InStr (str1, str2, compare)
Where:
• str1 is the text string to be searched.
• str2 is the text string being sought within str1.
• compare is an optional number value indicating which type of string comparison should be used.
0 indicates case-sensitive comparison
1 indicates case-insensitive comparison. If this argument is not used, a case-sensitive comparison is performed.
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To