Home Forums SQL Server 2005 T-SQL (SS2K5) Using Lile and OR in a WHERE clause RE: Using Lile and OR in a WHERE clause

  • November 18, 2015 at 8:57 am

    #1840731

    Michael L John (11/16/2015)

    For starters, you cannot use a case statement in a where clause in this manner.

    More specifically, CASE statements cannot return Boolean values, because SQL does not have a Boolean datatype. (Although you can model some of the aspects of a Boolean datatype with BIT.)

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA