Concatenation function

[angel1234]

hi,
i have a requirement like i need to pull date from oracle db and display it as 'dd-mmm-yy-ddd' format.So i pulled date and day(using to_char(date,'dy')) in two separate variables from oracle and tried to concatenate in ti process .but i didnt find a function to concatenate it in the turbo integrator.IS there any function to do it?

thanks and regards,
angel

[Alan Kirk]

hi,
i have a requirement like i need to pull date from oracle db and display it as 'dd-mmm-yy-ddd' format.So i pulled date and day(using to_char(date,'dy')) in two separate variables from oracle and tried to concatenate in ti process .but i didnt find a function to concatenate it in the turbo integrator.IS there any function to do it?

It's not a function; you use the pipe character as the concatenation operator. It's just above the [Enter] key.

Code: Select all

s_WholeString = 'SubString1' | 'Substring2';