Case statement for multiple columns

by

It doesn’t appear that your desired logic is complete. Such as what do you actually want the value to be retain current colA value? and you are writing colb = 1 then colC = ‘Tom1’… I will assume then is supposed to be and.

CASE
   WHEN colB = 1 and colC = 'Tom1' THEN ????
   WHEN LEFT(colD) = 'Jef' AND colC = 'Tom2' THEN ????
   ELSE NULL
END

If you just want to retain the ColA Value then you can actually combine yoru case statements with an OR

CASE
   WHEN (colB = 1 and colC = 'Tom1')
        OR (LEFT(colD) = 'Jef' AND colC = 'Tom2') THEN colA
   ELSE NULL
END

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to get a particular preceding value of a column in SQL [closed]
  3. How to select just the row in the second table?
  4. Find number of days that intersect a given date range in a table of date ranges
  5. Insert results of a stored procedure into a temporary table
  6. Best approach to remove time part of datetime in SQL Server
  7. SQL Server : Columns to Rows
  8. Difference between JOIN and INNER JOIN
  9. SQL NVARCHAR and VARCHAR Limits
  10. How important is the order of columns in indexes?
  11. Remove Identity from a column in a table
  12. Why no windowed functions in where clauses?
  13. efficient way to implement paging
  14. SQL Server – transactions roll back on error?
  15. T-SQL Cast versus Convert
  16. SQL Case Sensitive String Compare
  17. What is a stored procedure?
  18. Exporting data In SQL Server as INSERT INTO
  19. convert Excel Date Serial Number to Regular Date
  20. Convert Comma Separated column value to rows
  21. Partition Function COUNT() OVER possible using DISTINCT
  22. What does sp_reset_connection do?
  23. Replace first occurrence of substring in a string in SQL
  24. How to correctly insert newline in nvarchar [duplicate]
  25. Using IF ELSE statement based on Count to execute different Insert statements
  26. SQL Server SELECT INTO @variable?
  27. Select a column if other column is null
  28. How to subtract 30 days from the current date using SQL Server
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment