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