concatenating

[janardhan]

Hi ,

i need to concatenate two columns in the same table.

Can u pls explain...

eg: Sector table:

      a ,

      b,

      c,

      d

like this...

i need to display as a+b value in single column

[jagan · Accepted solution]

Hi Janardhan,

LOAD

     ColumnA,

     ColumnB,

     ColumnA & ColumnB AS ConcatenatedColumn

FROM DataSource;

Hope this what you are expecting, if not explain with an example.

Regards,

jagan.

[janardhan]

thanks jagan.....