Hi ,

This question was answered befor but I am unable to find it...

I have 2 address columns and i want to display them one below the other.

Eg:

Address1 Address2
21,Shinjuku, Tokyo,Japan.

Result desired :

Address
21,Shinjuku,
Tokyo,Japan.

I remember that it could be done using char() but not sure.

Thanks.