Instr Function Cognos Report

Question

I am trying to find the @ in a string field. The follow data item in a Congos 8 returns

0

for every call.

instr 
(
[email protected], '@', 1
)

Any ideas? New to Cognos and Oracle in general but I feel like I have to be missing something obvious.

Answer 1

Does Cognos even have an InStr? I've always used Position for this.

A little more digging reveals InStr as an Oracle function but I'm not sure on the interplay between the database and Cognos since we just use the database for getting data, all user manipulations of the data are handled purely on the Cognos side for us.

But, even if that worked properly, it seems to me that your first argument should be quoted as well, yes? It is supposed to be a string after all.