Concatenation with null

Now for our trick. Let me explain. Now for a final explanation of why the second method returned better results as compared to the first. In other words, a Null is concatenated to Spearman. Give it a try and see if that works for you. Seth Spearman. When doing something like this, I like to use the IIF function within my concatenation formula. The IIF function returns one value when a condition is true and another value when false.

You'll need to concatenate all these together and still play with the commas a bit to get the formatting perfect, but that is the way I would approach it. Please support the forum! Thank you for the quick reply. Will give it a go!!

Glad to hear it. I have all the Crystal Reports formulas and sample code document in three chapters in my book Crystal Reports Encyclopedia. I actually bought your book last year.

Has tons of great info. I would have referred to it but a friend borrowed the book a few weeks ago and has not returned it. Jonathan Leffler Jonathan Leffler k gold badges silver badges bronze badges. So in cases where Middlename or Firstname is null, you won't get extra unwanted spaces. Client Relations Client Relations 69 7 7 bronze badges. This is perfect! If you are using MySq, use ifnull Column2, ''. CapelliC CapelliC Chris E Chris E 13 13 silver badges 26 26 bronze badges. Chris Chris 3, 1 1 gold badge 17 17 silver badges 26 26 bronze badges.

Chris Cooper Chris Cooper Adam, actually no-one had yet suggested the case expression as solution. I think your assessment is maybe too harsh. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.

Podcast Making Agile work for data science.