Concatenating two integers

[BregjeE]

I am trying to concatenate 3 fields for someone's address. The first contains the streetname, the second the number and the third contains additional information. This additional information can be either numeric or character.
For example: someone lives at St Jacob Street 12-15
Field1: St Jacob Street
Field2: 12
Field3: -15
I have to concatenate the three fields to get the full address, but when I try this the result is as follows:
St Jacob Street -3.
The second and the third field are substracted, in stead of concatenated. I've already tried a lot of different functions (FormatNumber, Char, etc.) but I haven't found the solution yet.
How can I force BO to concatenate the fields in stead of calculate??

tia, Bregje

 

[BobWard]

FormatNumber(Dimension,"0&quot is what you need to use.

 

[blom0344]

Hello Bregje,

Concatenation of fields seems to be easier in the universe than within a report. Possibly this is because the universe can benefit from the specific functions that are available in the database type you are working on. I create universes on both ORACLE and DB2 and there is significant difference between functions available. I do not know on which type of database you work , but try to create a new object in the universe that performs the concatenation.

On DB2 an expression as char(numfield1)||textfield||char(numfield2) works just fine.

 

[upstater]

Try &quot; & &quot;. I think you can just create a variable defined as a <dimension 1> & <dimension 2> etc.,... Add spacing using &&quot; &quot;&