title: How to get comparison operator from string to where clause
body: <p>I have data in reference table  like &lt;55, >60 (etc) and in source the values will come 40, 70 (etc). So based on reference values I have to check condition.</p>
  
  <p>Example ;</p>
  
  <p>if the value reference table  is &lt;55</p>
  
  <p>my condition in where clause  would be 40&lt;55</p>
  
  <p>if it is >70</p>
  
  <p>my condition in where clause would be  </p>
  
  <p>40>60</p>
  
  <p>actaully I am checking multipule condition on different fileds on where where .. this is going to be one of condition with AND.</p>
  
  <p>Can you suggest me the way to handle it .</p>
  
  <p>Thanks in advance</p>