Search results
15 mar 2013 · CASE LEN(ISNULL(last_Name,'')) WHEN 0 THEN '' ELSE ' ' + last_name END AS newlastName LEN(ISNULL(last_Name,'')) measures the number of characters in that column, which will be zero whether it's empty, or NULL, therefore WHEN 0 THEN will evaluate to true and return the '' as expected.
26 lip 2013 · In this situation you can use ISNULL() function instead of CASE expression . ISNULL(B.[STAT], C.[EVENT DATE]+10) AS [DATE]
Using ISNULL: Use the IsNull function to substitute the words No summary for rows where the Summary column is null. Using COALESCE: Do the same thing, but using the COALESCE function instead. Using CASE: Use a CASE WHEN statement to show different things according to whether the Summary column is null or not.
There are 3 possible ways to deal with nulls in expressions: using IsNull, Coalesce or CASE. I've explained these under separate headings below! The ISNULL Function. This function substitutes a given value when a column is null. The syntax is:
The SQL CASE Expression. The CASEexpression goes through conditions and returns a value when the first condition is met (like an if-then-else statement). So, once a condition is true, it will stop reading and return the result. If no conditions are true, it returns the value in the ELSEclause.
This tutorial shows you how to use two forms of SQL CASE: simple CASE and searched CASE expressions to add the IF THEN ELSE logic to SQL statements.
11 lip 2012 · Is there any better way to write the lines below in SQL Server 2005? CASE WHEN (ID IS NULL) THEN 'YES' WHEN (ID IS NOT NULL) THEN 'NO' END AS ID_Value, sql-server
