Home Forums SQL Server 7,2000 T-SQL Doing Short Circuiting in WHERE clause RE: Doing Short Circuiting in WHERE clause

  • July 28, 2003 at 5:48 am

    #467238

    Not exactly using CASE, but this should do the trick :

    

    SELECT *

    FROM MyTable

    WHERE IsNull(FirstName, <Name to look for>) = <Name to look for>

      AND IsNull(LastName, <Name to look for>) = <Name to look for>