Select help. Conditions

• vmon

  SSChasing Mays

  Points: 624

  More actions

  April 26, 2005 at 9:43 am

  #65799

  I need to select records based on the value of 3 boolean columns.  I need to select true, false, or both depending on user prompt.  I have little t-sql experience and am not sure where to begin.  CASE or IF.  Will I need three queries for each column and use an for to test for my user criteria?

  Help!,

  vmon

• john-132685

  SSCertifiable

  Points: 6134

  More actions

  April 26, 2005 at 1:30 pm

  #555009

  Use CASE, refer to the books on line