3 Replies Latest reply on Oct 13, 2015 5:08 PM by Gary Graham-Oracle

    Having  ( ) and & in the values


      Hi All,

      I have a simple case statement

      case when descr= 'book' then 1

             when descr='SUPPORT (COPYING & SORTING FILES)' then 2

             else null end

      when i run the query am getting NULL wherever i have descr as 'SUPPORT (COPYING & SORTING FILES)'. I know its because of the  ( ) and & , can some one please guide me to a link where i can deal with these kind of situations? I looked up and found notes on how to deal with & , but that didn't work.please need help.