Hi,

May I know how to concat two column value?

For example I have following table

Column1	Column2
Happy	Birthday
Flying	Fox

How to concat column1 and column2 so that I get the following result

Word

Happy Birthday

Flying Fox

I try to concat these two column in enesys sqlquery but it fails.

Please help....

Hi,

The solution proposed by Marien works perfectly.

However, I’m wondering why you would not concatenate the strings directly within your report using a report expression. Is there any specific reason?

Regards,

---

Frederic LATOUR
ENESYS

Hi,

I want to display the concat text on combobox. For example, staff id + staff name. It would be good if the combobox can support multicolumn but the trick to achieve that is concat these two value.

By the way, I can't find it to do within report expression. Thanks for help :)

Regards,

Carles