title: Is is possible to use the CASE statement within the WHERE CLAUSE in this format
body: <p>I have written an SQL query that will return a set of results but the result set that has been returned is not precise enough! So what I am trying to do now is to trim the result set down to get the exact information that I require! Each Item that I want is coming back with multiple rows and I am looking for a particular row to return to the user.</p>
  
  <p>So I want to search for a value within my where clause and only select the desired criteria from that item! I have written this case statement within my where clause but I can't get it to function effectively:</p>
  
  <pre><code>and SourceType.Name = (CASE When SourceType.Name = '7550RTU' Then 
                          Select Quantity.Name from Quantity
                          Where Quantity.Name = 'DI-S1 Cnt'
                      End)
  </code></pre>