title: how to find if incomming parameter in not null and not empty in Sybase
body: <p>I am trying to write some thing like this in sybase ASE</p>
  
  <pre><code>@searchstring varchar(500)
      If(IsNULLorEmpty(@searchstring))
      {
  
      exec(@strexecsql)
  
      }
      else
      {
  
      exec(@strexecsql1)
  
      }
  </code></pre>
  
  <p>what is best way to check this condition IsNULLorEmpty for a incoming @parameter?</p>