Forum Stats

  • 3,874,594 Users
  • 2,266,750 Discussions


Beginner question

3004 Member Posts: 204,171 Green Ribbon
Please excuse my newness (ignorance). Discoverer has just recently been loaded on our machines. I am trying to create some reports for the guys. I am trying to use DECODE. I am familiar with Access so I will use it's terminology. I want to do this: If product_name is like "SD CN%' then = units, if not = 0. When I try this with DECODE I get a syntax error. I am thinking I am not using the 'LIKE statement properly. Please respond. Thanks.


This discussion has been closed.