Hi Guyz, i wanted to concatenate 3 fields and display the result. but concat() is taking only two fields as parameter. i want to concat first_name,last_name,mid_name. can any body suggest answer for it.
I will prefer to use StringBuffer as using concat on String should be avoided.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
posted 13 years ago
Hi Shailesh, I dont understand about your query...
According to my experience, there is no keyword StringBuffer in SQL keywords. StringBuffer is Java object and we cannot mix that into our sql query.
I think we can use StringBuffer to compose that name in application side. After we receive ResultSet, we can get first_name, mid_name and last_name. And then using StringBuffer to compose that value...
Correct me if I am wrong to understand your words thanks daniel