title: I need to make the column values of a table case Insensitive while reading them in a Spotfire Prompt from a Oracle View
body: <p>I am loading data into Spotfire report from Oracle using view. In the Spotfire Prompt when the text value is entered, whether it is Upper,lower or mixure of both the relative column values should be displayed. Since this is done at the data base level i need some way to make the column values case insensitive. 
  I know that column values can be converted to upper/lower case with upper()/lower() function but i need a way so that even a mixure of upper/lower cases will search the column values.
  I found one more solution for session :</p>
  
  <pre><code>alter session set NLS_COMP=ANSI;
  
  alter session set NLS_SORT=BINARY_CI;
  </code></pre>
  
  <p>After using the above code any SQL search for column will be case insensitive. but i need a solution where i can use it in the view of the column element. </p>