I want to select a set of results that, passing the option by like, but the result can be that it is lowercase or capitalized. I did this way:
SELECT * FROM DocumentosAux WHERE numeroDocDisco like binary 'pbra';
SELECT * FROM DocumentosAux WHERE binary numeroDocDisco like 'pbra';
But none of the forms gives the desired result, since it could be written as Pbra, pBra, PBRA, etc.