INSTR treated like an ARRAY ?

[medieval]

I'm using Crystal V10 and have entered InStr({CS_CONTACTS.EMAIL_ADDRESS},{?EMAIL_ADDRESS}) but this is treated like an array for some reason and a prompt denotes that this array should be treated as a subscript. Any ideas as to why this is happening and what can be done to get the INSTR effect?

 

[Turkbear]

Hi,
Entered where?
How are you trying to use that formula and what is the desired outcome?

All strings, for manipulation purposes, ARE arrays ( of letters)..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[medieval]

this is entered in select expert as part of the formula editor. i'm trying to see if a discrete parameter appears in any part of a table.field, if so then i can include this in a gorup.

 

[Turkbear]

Hi,
Try

{CS_CONTACTS.EMAIL_ADDRESS} like  '*' + {?EMAIL_ADDRESS} + '*'

To Paraphrase:"The Help you get is proportional to the Help you give.."