stringA + stringB ... when one is null

[Fursten]

Hi,

I have a formula that concatenates strings like this:

stringA + ' ' + stringB

The problem is that, if one of the string as the null value I will not obtain the value of the other that is not null.

For instance, if StringA = null and StringB = 'Test'

I would like to have:stringA + ' ' + stringB = 'test'

Any ideias?

Thank you,

Sergio Oliveira

 

[mbarron]

A possible work around is to create a formaula that will cause a null field to be a blank string.

If isnull({stringA}) then "" else {stringA} Mike

 

[mbarron]

My previous post was incomplete. Sorry.
PREVIOUS POST ... then concatenate the formula(s) that you create.
Mike

 

[dgillz]

if isnull({StringA}) then {StringB} else
if isnull({StringB}) then {StringA} else
{StringA}+" "+(StringB} Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office