STRVAL(myValue) IS NULL
A slight variation, without concatenation:
WHEN myTextField IS NULL
very good, probably faster than mine, thanks !
It seems COALESCE is not a popular word in English.
An astute observation.
I think the point was:
SELECT COALESCE ( myTextField , 'SomePlaceHolder' ) FROM ...
the original field is numeric, so COALESCE alone won't work, but
I think the point was
I know. Thanks anyway for spelling it out for posterity.
Hahamet the word first time when learning SQL, hadn't learn the word in school days..
Me neither; first time I saw it was when reading this novel:
COALESCE is a better function, but I found ISNULL is easier to remember and spell ( and in my case to pronounce ). Shame it was not included in FQL.
ISNULL is a bit self-explanatory as well.
I figured you knew this - but since it wasn't explicitly stated, I thought that anyone reading the thread who didn't know, might like to know. Ya' know?
I thought that anyone reading the thread who didn't know, might like to know.
spelling it out for posterity.
I imagine that the ESQL solution you found would be quite efficient and fast and more straightforward, but a possible FileMaker solution would be to include a 2nd value in your SELECT that always has a value, and then the data value would sometimes be empty.
So SELECT the record ID and the data value: 1234123,17.5; 1234564,20.1; 1235103,; etc. Then you could do a substitute operation on the missing values: substitute ($list ; ",;" ; "; NULL;" ).
But then you have to strip out the 2nd column of data in some manner. So hence less straightforward than the SQL solution.