1438060 - How to search a memo field in Crystal Reports formula for a case sensitive string

SAP Knowledge Base Article - Public

1438060 - How to search a memo field in Crystal Reports formula for a case sensitive string

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 BusinessViews Manager , How To

Product

Crystal Reports 2008 V1