Concatenate columns in IBatis

[Yan Hu]

Hi guys:
I would like to concatenate a few columns and then map it onto a single property in a java bean
For example
Select col_a || col_b as id from aTable

When it runs, it complains about �|| col_b � as a invalid column. Obviously IBaits did not try to concatenate these 2 columns.

Thanks for any input.