Empty select in formula in Crystal 9.2 1

[lana123]

Hi,people.
To show last and first name in report(Oracle db) I'm using the formula based on my view fields:
UCASE({RPT_CLAIMANT.LAST_NAME})+
IF UCASE({RPT_CLAIMANT.FIRST_NAME})='' Then ''
Else ', '+UCASE({RPT_CLAIMANT.FIRST_NAME})

If I don't have firstname nothing shows up in the formula.
I cannot understand why it's happen.
Please,advise...
Thanks,

Lana

 

[lbass]

Try:

UCASE({RPT_CLAIMANT.LAST_NAME})+
(
IF isnull({RPT_CLAIMANT.FIRST_NAME}) or
trim({RPT_CLAIMANT.FIRST_NAME})= '' Then ''
Else ', '+UCASE({RPT_CLAIMANT.FIRST_NAME})
)

-LB

 

[lana123]

Thanks a lot!
It works!

Lana