I have an HQL query that works pretty well, it gets what I have requested it to find ... However,

The code which Hibernate is replacing performed case sensitive searches of the database; that is, If I have "Fred" stored in the databse and guery for "fred" it would not find that. It would only find "Fred" if I queried for "Fred".

Is there any way to force that behavior with Hibernate?

Thanks.

just make everything uppercase for the query.

from Table t where upper(t.name)=:name

and in your code make everything uppercase just for query use.

But how does that make my queries of data in the database case sensitive? It seems to me that this just ensures case insenitivity, which is essentially what I am experiencing now.

Let me clarify: If I have stored in the database the string value, "Fred", and the user enters "fred" in the search screen, I want the search to FAIL to find anything (assuming I do not have value "fred" in the database). I want the search to succeed only if the user enters "Fred" (exact, by case).

I want to know if I can force Hibernate to behave in its queries (this specific query) in a case sensitive manner.

If I remember correctly, SQL string matching is case-insensitive, so you need to look at vendor-specific options (collation?).