Need syntax help with this
WHERE INDEX_CODE CONTAINS 'S&P 500';

This keeps asking me INPUT P.

Please help this Novice user.
Thanks

This message has been edited. Last edited by: <Emily McAllister>,

Webfocus is thinking that &P is an amper variable so it is looking for a value for it. One way to get around this is to do this:

-SET &P = '&' | 'P';

Hopefully that works.

This might work also:

WHERE INDEX_CODE CONTAINS 'S&|P 500';

Yes, both options worked.
Thanks guys.

FYI

I would characterise the pipe character like an escape character for the amper character, but is used after it.