I am trying to find all the name that starts with either A,B or C in Oracle DB and I wrote this syntax:
SELECT NUME FROM JUCATORI
WHERE NUME LIKE '[ABC]%';
but it doesn't not give me any name (neither error), even though I am sure I have in my DB names that starts with either A,B or C.
One option is
where substr(nume, 1, 1) in ('A', 'B', 'C')