COGNOiSe.com - The IBM Cognos Community

Hi Everyone

I am having problem in using substring on the session parameter.
for example:

  session parameter:   account.personalinfo.userid
    value:                   FGT12345

I need only first three letters.

question: can i use substring / sould i create a custom session parameter?

Please help me.

Thanks

Cog Boy

Syntax for SQL Server:

substring(#sq($account.defaultName)# ,1,3)

Syntax for Oracle:

substr(#sq($account.defaultName)# ,1,3)


sq() is a macro function to add single quotes around the string paramter, which is required by the subtring functions.  Because it is a macro function, it must be inside the # delimiters.

Excellent example!