do case insensitive search using nxql

[ITShine_]

i'm using Nxql to do search on my custom document types, but i've noticed that with this NXQL query :

<fixedPart>
                ecm:isCheckedInVersion = 0 AND
        				ecm:mixinType != 'HiddenInNavigation' AND 
        				ecm:currentLifeCycleState != 'deleted' AND ecm:parentId = ? AND
        				ecm:primaryType = 'fiche_technique' 
          </fixedPart>

the search is case sentitive, i mean "work" and "Work" are not the same with this query , can you tell what should i add in order to have a case insentitive search ?

[Thierry_Martins · Accepted solution]

hello,

you need to use the ILIKE operator to do case insensitive search.

Regards