how do I select a column based on condition?

by 
SELECT ordr_num as num, ordr_date as date, 
    CASE WHEN @status<>'Cancelled' THEN ordr_ship_with ELSE NULL END as shipwith 
FROM order 
WHERE ordr_num = @ordrNum

Related Contents:

  1. Function vs. Stored Procedure in SQL Server
  2. How can I get column names from a table in SQL Server?
  3. How can I list all foreign keys referencing a given table in SQL Server?
  4. How to select all records from one table that do not exist in another table?
  5. OR is not supported with CASE Statement in SQL Server
  6. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  7. Select statement to find duplicates on certain fields
  8. T-SQL Cast versus Convert
  9. When to use Common Table Expression (CTE)
  10. How do I create a foreign key in SQL Server?
  11. How can a LEFT OUTER JOIN return more records than exist in the left table?
  12. Change Schema Name Of Table In SQL
  13. How to calculate age (in years) based on Date of Birth and getDate()
  14. CROSS JOIN vs INNER JOIN in SQL
  15. Difference between CTE and SubQuery?
  16. How to report an error from a SQL Server user-defined function
  17. Getting result of dynamic SQL into a variable for sql-server
  18. How to assign an exec result to a sql variable?
  19. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  20. How to force a SQL Server 2008 database to go Offline
  21. Aggregate function in an SQL update query?
  22. COALESCE Function in TSQL
  23. SQL Row_Number() function in Where Clause
  24. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  25. Declare Variable for a Query String
  26. SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, =
  27. How do you update a DateTime field in T-SQL?
  28. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  29. Conditional WHERE clause in SQL Server
  30. SQL Server Invalid Column name after adding new column
  31. What is the equivalent of the Oracle “Dual” table in MS SqlServer?
  32. Limit on the WHERE col IN (…) condition
  33. How to send email from SQL Server?
  34. Can an INNER JOIN offer better performance than EXISTS
  35. How do I create a comma-separated list using a SQL query?
  36. How to retrieve records for last 30 minutes in MS SQL?
  37. Comparing two bitmasks in SQL to see if any of the bits match
  38. What’s the SQL national character (NCHAR) datatype really for?
  39. T-SQL: Selecting Column Based on MAX(Other Column)
  40. T-SQL split string based on delimiter
  41. DateTimeOffset.Now in T-SQL
  42. Where value in column containing comma delimited values
  43. Using DISTINCT and TOP in the same query
  44. SQL: How do I use parameter for TOP like in SELECT TOP @amount? [duplicate]
  45. Query error with ambiguous column name in SQL [duplicate]
  46. How do I list user defined types in a SQL Server database?
  47. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?
  48. SQL Server Left Join With ‘Or’ Operator
  49. In SQL Azure how can I create a read only user
  50. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon

Leave a Comment