Trying to create concatenation formula and it doesnt show correctly

[jspur2003]

Im using Crystal Reports 8.5 and Im trying to create a formula that has a concatenation... What im running into is one field has null values two fields are item and container... They both are string values and when i try to concatenate the two fields together example of data in the 2 fields
<code>
Item field Container field
1001-RJJ QT
1005-RPM 4
1023
101-XYZ 2
</code>
And what i want to accomplish is this
<code>
1001-RJJ/QT
1005-RPM/4
1023
101-XYZ/2
</code>
When I set up the formula i try this and get this result
<code>
code:
{Lot.ITEM} & "/" & {Lot.Cont}
Results:
1001-RJJ/QT
1005-RPM/4

101-XYZ/2
</code>
As you can see it leave a blank space where 1023 should go how can i write a formula that will show the 1023 in the mix??? Any help is greatly appreciated...

 

[synapsevampire]

Try:

if isnull({Lot.Cont}) then
{Lot.ITEM}
else
{Lot.ITEM}& "/" & {Lot.Cont}

-k