Search results
26 lip 2013 · In this situation you can use ISNULL() function instead of CASE expression . ISNULL(B.[STAT], C.[EVENT DATE]+10) AS [DATE]
The SQL CASE Expression. The CASE expression 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 ELSE clause.
11 lip 2012 · Yes - I did try CASE WHEN (ID IS NULL) THEN 'YES' ELSE 'NO' END AS ID_Value But I am looking for some other better approach something like IF(ID IS NULL, 'YES', 'NO') AS ID_Value in the Ms Sql, so that everything can be in a single line. Any suggestions please –
18 mar 2013 · After a quick look it turned out to be a CASE expression problem when dealing with NULLS. In the first format we make simple “equals to” comparisons to a value: SELECT CASE <value>. WHEN <equals this value> THEN <return this>. WHEN <equals this value> THEN <return this>. -- ... more WHEN's here.
3 wrz 2024 · The CASE expression has two formats: The simple CASE expression compares an expression to a set of simple expressions to determine the result. The searched CASE expression evaluates a set of Boolean expressions to determine the result.
24 sty 2013 · If you're just checking for NULL values, you might try ISNULL() and cast the date as a varchar. SELECT ISNULL(CAST(fu.SentOutDate AS VARCHAR(50)), '') AS SendOutDate FROM tablename Share
The first format for the CASE expression has the following syntax: CASE WHEN <condition> THEN <expression if true> ELSE <expression if false> END The ELSE argument is optional.
