On Wed, 20 Nov 2013 09:03:32 +0000 Joe <[email protected]> wrote:
> > I spent some time trying to print > addresses. Postal addresses have varying fields present, and I don't > want blank lines in the middle of my printed addresses. My Access > solution involves a large ugly mess of IF statements, but it's simple > and it works beautifully, and I had no success in trying to implement > something similar in LO... > ...which is often a sign of looking in the wrong place. OT, but in case anyone stumbles across this thread while looking for the same thing: The right place is in the MySQL documentation for concat_ws(), which does pretty much exactly what I want, and even handles NULL fields without masses of ugly code. Not portable across databases, but I'll deal with that if/when I have to. -- Joe -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected] Archive: http://lists.debian.org/[email protected]
