title: String.IsNullOrEmpty like function for VARCHARs in SQL?
body: <p>Say I've got a function or stored procedure that takes in several VARCHAR parameters.  I've gotten tired of writing SQL like this to test if these parameters have a value:</p>
  
  <pre><code>IF @SomeVarcharParm IS NOT NULL AND LEN(@SomeVarcharParm) &gt; 0
  BEGIN
      -- do stuff
  END
  </code></pre>
  
  <p>There's gotta be a better way to do this.  Isn't there?</p>