<snip> > (Why else is COUNT(VAR,@FM)+(VAR NE "") syntax so popular?) <\snip>
Because there is a real difference between COUNT and DCOUNT. COUNT counts the number of delimiters and DCOUNT counts the number of elements being delimited. Sort of backwards but accurate. Thus A="mark" would have COUNT(A,@VM) have a value of 0 while DCOUNT(A,@VM) would be 1. DCOUNT on null string returns 0. Nice. The addition of the +(VAR NE "") adds the needed '1' to whatever COUNT produced. my 1 cent. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
