title: Want to know first character CharIndex
body: <p>In Below example i Want to know charindex of first character except spaces tabs newlines etc.</p>
  
  <p>I am not able able to do that because <code>CHARINDEX()</code> function of SQL want character for index
   but in my string anyone comes dynamically.</p>
  
  <pre><code>Declare  @str varchar(100)
  set @str='      test String'
  </code></pre>
  
  <p>in above case i want charindex of 't' (means first character of string)</p>
  
  <pre><code>  set @str='              String test'
  </code></pre>
  
  <p>in above case i want charindex of 'S' (means first character of string)</p>
  
  <p>Anyone please suggest me the solution.</p>