Help with HQL query ( Concatenate two columns)

mpakala · **Posted:** Wed Mar 12, 2008 5:24 pm

Hi

I need help with HQL to do something like this

Select concat(p.firstname,' ',p.lastname) from person p

OR

Select p.firstname||' '||p.lastname from person p

I dont know if this can be done. I saw similar discussions but I have not seen a solution. The NHibernate version i'm using is 1.2.0.4000.

Please help me out.

thanks
kiran

wolli · **Posted:** Thu Mar 13, 2008 3:07 am

Never tried it, but according to the documentation || should work:

http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/queryhql.html#queryhql-expressions

Have you tried it ? Post the exception if you got one.

pyhavaim · **Joined:** Sun Oct 22, 2006 12:06 pm **Posts:** 39

the simplest thing is to have special readony property for customer
eg.

Code:

class Customer
{
public String FirsName {get; set;}
public String LastName {get; set;}

public String FullName {get{ return FirstName+" "+LastName;} }

}