If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filter on range of value: start with C00-C99

Started by peewan, 17 Feb 2021 04:52:57 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

peewan

17 Feb 2021 04:52:57 PM
I want to filter on any Code that start with C00-C99 and M00-M99
example: C00001, C25003, C89000, C99045...

How could I do this?

Thank you

BigChris

#1
17 Feb 2021 04:57:07 PM Last Edit: 18 Feb 2021 02:08:45 AM by BigChris
Code Select
substring([CodeField],1,3) between 'C00' and 'C99' or substring([CodeField],1,3) between 'M00' and 'M99'
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite