• Post Reply Bookmark Topic Watch Topic
  • New Topic

how to use sql functions inside criteria?

 
shah rah
Ranch Hand
Posts: 124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to comapare name from database(can have mixed case) and the name user has entered.

I need to do something like


I am using criteria


How to use the LOWER sqlSERVER function inside Criteria?
 
Mark Spritzler
ranger
Sheriff
Posts: 17309
11
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I believe in Expression or maybe it is actually the Criteria object that has a ignoreCase() method, or the like.

Mark
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!