Re: [GENERAL] coalesce for null AND empty strings

2007-04-02 Thread Ferdinand Gassauer
On Friday 30 March 2007 10:19:35 Richard Huxton wrote: > Don't forget to cc: the list! snip > > OK this shortens the function, but does not help to "solve" the coalesce > > problem > > coalecse(empty2null(var1),empty2null(var2),empty2null(var-n)) > > instead of > > coalecse2(var1,var2,...var-

[GENERAL] coalesce for null AND empty strings

2007-03-29 Thread Ferdinand Gassauer
Hi! it would be great to have a coalesce2 function which treats empty strings as null values. as far as I have seen, there are a lot of comments and coding solutions about this, but none is an "easy" one and all make the code a bit more complicated and more difficult to maintain. I have creat