title: How to use decode in IICS when field data contain single quote?
body: <p>I am new to <code>IICS</code> and my fields that I want to decode looks like below. As you can see the &quot;Outlet_Name&quot; column contains row &quot;NH D'needs&quot;. My requirement is to use both columns i.e. Outlet_name and Department and generate an output field call &quot;OD_ID&quot; which consist of integers. So <code>Decode</code> will look like below. However, when I run below decode expression I am receiving validation error saying missing operator. I believe this has to do with the single quote present between D and needs in &quot;NH D'needs&quot;. Not sure how to proceed from here ?</p>
  <p>Thanks in advance for your time &amp; efforts!</p>
  <p><a href="https://i.stack.imgur.com/YmVIB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YmVIB.png" alt="enter image description here" /></a></p>
  <p><strong>IICS Decode code</strong></p>
  <pre><code>DECODE(True,
  Outlet_Name = 'NH D'needs' AND Department ='Marketing' , 1,
  Outlet_Name = 'NH Mart' AND Department ='Finance' ,2,
  Outlet_Name = 'NH Groceries' AND Department ='Inventory' ,3,
  Outlet_Name= 'NH Lifestyle' AND Department ='Marketing' , 4,
  Outlet_Name = 'NH Digital' AND Department ='Logistics' , 5,
   0
  )
  </code></pre>