functions

[johny.cbi]

I need to say in my report show me zip code >50000 and <55000

so i need the zip code to be a number

the zip code is a varchar i believe, text

can I use cast function or to_number function?

[blom0344]

to_number is specific for Oracle. If you can use a Cognos function, then this should be the one to go for.
So, use the cast construction from the set of cognos functions..

[johny.cbi]

I have a ZIP code item like this 
[Business View].[First Primary LIVE].[Zip Code],
my Data Base is Oracle, cognos 8.1v

could you please give me the example from the above Zip code item

[blom0344]

When in Report Studio press F1 then search for 'using the expression editor' on how to use the Cast function..

[JGirl]

Have you tried just using [Business View].[First Primary LIVE].[Zip Code] between '50000' and '55000' without casting it at all?

J