Timeline for Matching empty string is not working
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 19, 2016 at 19:35 | comment | added | SQLDevDBA | I'd also suggest adding the CASE statement you have into your SELECT statement so that you're able to see what the JOIN is working with. That might bring a few things to light for you. Maybe change your THEN statements to THEN 'Then1', THEN 'Then2' and THEN 'Then3', and also your "ELSE Box.Ice" to : "ELSE 'ElseReached' and see if you can track it down and confirm which CASE is being reached. | |
| Jul 19, 2016 at 19:09 | comment | added | Vaccano |
I updated the case statement to have WHEN ASCII(Box.Ice) = 0 THEN 'N' and that got the match I needed. Still seems odd to me though.
|
|
| Jul 19, 2016 at 19:08 | vote | accept | Vaccano | ||
| Jul 19, 2016 at 17:10 | history | answered | SQLDevDBA | CC BY-SA 3.0 |