# Revision history [back]

Hello @ Joe Castor,

You shoul be able to do this with CASEWHEN. For example, it appears your "Address2" is one of the optional fields. So, instead of:

|| "MemberMaster"."Address2" || CHAR( 13 )

Use:

|| CASEWHEN("Address2" IS NULL,'', "MemberMaster"."Address2" ||CHAR(13))

in its' place. BTW, it is two apostrophes between the commas after IS NULL & before MemberMaster.

Hello @ Joe Castor,

You shoul should be able to do this with CASEWHEN. For example, it appears your "Address2" is one of the optional fields. So, instead of:

|| "MemberMaster"."Address2" || CHAR( 13 )

Use:

|| CASEWHEN("Address2" IS NULL,'', "MemberMaster"."Address2" ||CHAR(13))

in its' place. BTW, it is two apostrophes between the commas after IS NULL & before MemberMaster.

Hello @ Joe @Joe Castor,

You should be able to do this with CASEWHEN. For example, it appears your "Address2" is one of the optional fields. So, instead of:

|| "MemberMaster"."Address2" || CHAR( 13 )

Use:

|| CASEWHEN("Address2" IS NULL,'', "MemberMaster"."Address2" ||CHAR(13))

in its' place. BTW, it is two apostrophes between the commas after IS NULL & before MemberMaster.

Hello @Joe Castor,

You should be able to do this with CASEWHEN. For example, it appears your "Address2" is one of the optional fields. So, instead of:

|| "MemberMaster"."Address2" || CHAR( 13 )

Use:

|| CASEWHEN("Address2" IS NULL,'', "MemberMaster"."Address2" ||CHAR(13))

in its' place. BTW, it is two apostrophes between the commas after IS NULL & before MemberMaster.

Edit:

Once you have this solved & go to create a report, I can almost sense another question regarding this field in a report. See my answer first in this post.