SELECT USERID, NAMEFIRST, NAMELAST, DATEBIRTH
FROM APP.USER
#|USERID|NAMEFIRST|NAMELAST|DATEBIRTH
1|023|THOMAS|CARTER|
2|ABA|ALEXANDER|ANDERSEN|54142
3|ADC|ASHLEY|CORRONADO|49519
SELECT USERID, NAMEFIRST, NAMELAST, ISNULL(DATEBIRTH,'NULL')
FROM APP.USER
WHERE DATEBIRTH<>'NULL'
SELECT USERID, NAMEFIRST, NAMELAST, DATEBIRTH
FROM APP.
USER
WHERE DATEBIRTH IS NOT NULL
--
--
Caché, Ensemble, DeepSee
---
You received this message because you are subscribed to the Google Groups "Caché, Ensemble, DeepSee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-publi...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-public-cache+unsub...@googlegroups.com.
If you want to look at the global then “” is NULL and $c(0) is the empty string.
Seems backwards but if you think about how the values would get into the global it makes sense. To set a value to the empty string it must be specifically set by the user in either SQL or Objects. With a given value it is easy to convert it so we convert the empty string to $c(0).
If you don’t reference a property / field then it has a NULL value. Not providing a value for a list element or a piece of a string results in “” for a value in the global so that is NULL.
If you have a mix of using global sets with some Objects and SQL then things can be confusing because most COS application do not consider NULL and empty string to be 2 different things. Odds are the code for not providing a value and providing “” will do the same thing and the global will end up with “”
Brendan
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-publi...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
--
Caché, Ensemble, DeepSee
---
You received this message because you are subscribed to the Google Groups "Caché, Ensemble, DeepSee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-publi...@googlegroups.com.
On Oct 6, 2015, at 4:59 PM, Rosti <ros...@gmail.com> wrote: