Dear all,
The project I am involving right now deals with a lot data. So in order to optimize my searching criteria, i want to concatenate two variables(both are strings).
e.g. from Documents as docs where doc.fromZip+doc.toZip in ('005005'),
it didn't throw me any error, but didn't return anything either(should return one record though).
But I tried: from Documents as docs where doc.fromZip='a' in ('005a'), it gives me the correct results.
Can anyone explain why is it? Does that mean Hibernate won't allow you concatenate two variables?

Thank you very much!

What is your database's string concatenation operator? It is usually: ||

I've tried ||, but it threw an error. My db server is MySQL, anyway, I've found another way to bypass.
Thank you