Thank you, Miyako - I'm very glad to know that it is okay to continue to use ="" (in general) but I'm still trying to wrap my brain around the sorts of situations that might require using length=0
Given a group of records, * some created manually with data keyboarded in * some created programmatically with data imported from tab delimited text that was exported from Excel Will QUERY([Table];[Table]Field="") deliver the same results as it has in the past? Thank you! Janie ------------ Date: Mon, 5 Feb 2018 21:11:56 +0000 From: Keisuke Miyako via 4D_Tech <[email protected]> Hello, it is not a matter of western or non-western. the test for length=0 is only necessary if you can reasonable expect string that collates to "". c.f. $test:=""=Char(0) $test:=""=Char(1) //both is true otherwise you can continue to use ="" for queries and string in general. ------------ 2018/02/06 0:31ÅAwebmaster namethatplant.net<http://namethatplant.net> via 4D_Tech <[email protected]<mailto:[email protected]>> ÇÃÉÅÉãÅF QUESTION: In versions 12+, in unicode mode, if the field contains only routine Western characters, is it okay to continue to use QUERY([Table];[Table]Field="") and only if the field may contain nonWestern characters, use QUERY SELECTION BY FORMULA([Table];Length([Table]Field)=0) ??? ------------ ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
