Search code examples
cognoscognos-10

Cognos Report Studio - between and ends with syntax

I'm trying to create a detailed filter. I have a report which list down the items I need, but would like to further refine it.

[DB].[RP] BETWEEN ('XX80150P') and ('XX80220P')

The results give me enough information. but there are items which are like 'XX80150P660'. I want to exclude them. So I want to add ends with 'P'. Can anyone help with the "ends with" syntax please, in addition to the between.

Solution

  • Do you know standard SQL syntax? Add to your condition

    AND [DB].[RP] like '%P'