Hello! I don't recommend this since index can't be use in this case. Better introduce firstNameInUpper field.
Regards, -- Ilya Kasnacheev пт, 8 нояб. 2019 г. в 18:32, Humphrey <[email protected]>: > Thanks, is there a way to use IgnoreCase as well? > > IgnoreCase findByFirstnameIgnoreCase … where UPPER(x.firstame) > = UPPER(?1) > > > https://docs.spring.io/spring-data/jpa/docs/1.5.1.RELEASE/reference/html/jpa.repositories.html#jpa.query-methods.query-creation > > Or another way to do accomplish that with spring-data? > > Humphrey > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
