1 Reply Latest reply: Mar 6, 2013 2:06 PM by actdi RSS

    The symbol '' changes to a square box in ODI

    Prerna Vij
      Hi All,

      I have a query where there is a condition such as the one mentioned below:-

      DECODE (mc.CURRENCY,
      '','EUR',
      mc.CURRENCY
      )

      When I copy Paste this code the symbol '' gets converted to a square box and the condition returns no rows.

      I am able to see this symbol in Toad. But when I copy paste the same expression in SQL Developer it shows nothing.
      DECODE (mc.CURRENCY,
      ' ','EUR',
      mc.CURRENCY
      )



      Please suggest how to resolve this issue.

      Regards,
      Prerna