COncatenation with blank values

[dr.murthy]

Hi all,

Could you please let me know how to concatenate
two values with blank space.
my reqirement is some thing like
concatenate lastname and fristname
with blank value
foe example
fristname-->GIRI
lastname--->KIRAN
reqired reult is GIRI KIRAN
So far i tried with
fristname : ' ' : lastname

but its giving result 0

Any suggestions???

[syeed]

fristname-->GIRI
lastname--->KIRAN
fristname:' ':lastname

dont give any spaces in between and then try, it is working for me.

[syeed]

fristname-->GIRI
lastname--->KIRAN
fristname:' ':lastname

dont give any spaces in between and then try, it is working for me.

[nani0907]

Hi,
Are fisrt name and secomd names two different columns.

Use below logic

fristname : Space(1) : lastname .

Let me know how it works.

Thanks
Sana

[Sainath.Srinivasan]

What is the datatype for target column ?

[dr.murthy]

Hi,
Are fisrt name and secomd names two different columns.

Use below logic

fristname : Space(1) : lastname .

Let me know how it works.

Thanks
Sana

Hi ,

thanks for respond,

now its giving
fristnameSpace(1)astname.
not giving appropriate result

[richdhan]

Hi Murthy,

1. What is the stage you are using?

2. As Sainath asked what is the datatype of the target column

This is pretty straight forward. You just have to use a transformer and use the following derivation

LinkName.FirstName:" ":Linkname.LastName

HTH
--Rich

[dr.murthy]

What is the datatype for target column ?

Data type is varchar2

[chulett]

Where are you doing this, what stage?

[dr.murthy]

hi,


now its working fine.

Thanks

[rwierdsm]

If one of the variables are null, the whole string will evaluate to null: i.e.

Firstname: ' ' : Lastname

If Firstname = 'Rob'
Lastname - 'Wierdsma'
result will be 'Rob Wierdsma'

If Firstname = null
Lastname = 'smith'
result will be null.