SQL> SELECT 1 from Dual WHERE LTRIM ('12385x2', '0123456789') is NULL; unselected line SQL> SELECT 1 from Dual WHERE LTRIM ('123852', '0123456789') is NULL; 1 ----- -----1