title: Conditionally select value of a column based on another column
body: <p>I have a query that at high level is something like this:</p>
  
  <pre><code>Select SomeColumns, LastName, StartDateString
  from MyTable
  </code></pre>
  
  <p>Is it possible to have a logic in this select statement that can say print <strong>for value of "StartDateString" column</strong> the <strong>"not started"</strong> if <code>LastName</code> is for example <strong>"abcd".</strong> and print its real value otherwise. </p>
  
  <p>Basically I want to know how to write a logic for output of one column based on value of some other column in the same row. ( I am using <code>SQL Server</code> ) </p>