InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 12:39:42 GMT20http://www.sqlservercentral.com/Forums/Topic1408641-338-1.aspxPhil,Thanks for the help. I had tried the or logic, but something else must have affected the results.Tue, 22 Jan 2013 10:00:44 GMTMach1000http://www.sqlservercentral.com/Forums/Topic1408641-338-1.aspx[quote][b]Evil Kraig F (1/17/2013)[/b][hr]*facepalm* sorry about the earlier code. Try this again:Alternatively:[code="sql"]SELECT *, CASE WHEN column2 <> 'AP' THEN 1 ELSE 0 END AS APtest, CASE WHEN column3 <> 'U' THEN 1 ELSE 0 END AS Utest, CASE WHEN column2 <> 'AP' AND column3 <> 'U' THEN 1 ELSE 0 END AS APUtestFROM @Table1WHERE NOT ( column2 = 'AP' AND column3 = 'U')[/code][/quote][quote][b]Phil Parkin (1/17/2013)[/b][hr][code="sql"]--Statement 2select * from @Table1where (column2 != 'AP' or column3 != 'U')[/code][/quote]For those not versed in boolean logic:NOT ( column2 = 'AP' AND column3 = 'U') -->NOT(column2 = 'AP') OR NOT(column3 = 'U') -->column2 != 'AP' or column3 != 'U'Which means: NOT ( column2 = 'AP' AND column3 = 'U') is equivalent to: column2 != 'AP' or column3 != 'U'.Thu, 17 Jan 2013 16:58:44 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1408641-338-1.aspx*facepalm* sorry about the earlier code. Try this again:Alternatively:[code="sql"]SELECT *, CASE WHEN column2 <> 'AP' THEN 1 ELSE 0 END AS APtest, CASE WHEN column3 <> 'U' THEN 1 ELSE 0 END AS Utest, CASE WHEN column2 <> 'AP' AND column3 <> 'U' THEN 1 ELSE 0 END AS APUtestFROM @Table1WHERE NOT ( column2 = 'AP' AND column3 = 'U')[/code]Thu, 17 Jan 2013 16:14:52 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1408641-338-1.aspxEDIT: Scratch this, bad code. Sorry about that.Thu, 17 Jan 2013 16:10:17 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1408641-338-1.aspx[code="sql"]--Statement 2select * from @Table1where (column2 != 'AP' or column3 != 'U')[/code]Thu, 17 Jan 2013 15:30:25 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1408641-338-1.aspxConcerning the puzzle below, need a SQL guru to tell me how they solved this problem.Goal:To get statement 2 to produce the same results as statement 1 without having to string together the columns.DECLARE @Table1 TABLE(Column1 int IDENTITY(1,1),Column2 varchar(12),Column3 varchar(12))INSERT INTO @Table1 (Column2, Column3) VALUES ('UK','U')INSERT INTO @Table1 (Column2, Column3) VALUES ('AP','U')INSERT INTO @Table1 (Column2, Column3) VALUES ('AP','O')INSERT INTO @Table1 (Column2, Column3) VALUES ('UK','O')--Statement 1select * from @Table1where (column2 + column3 != 'APU')--Statement 2select * from @Table1where (column2 != 'AP' and column3 != 'U')Thu, 17 Jan 2013 15:25:24 GMTMach1000