LIKE 'pattern'The pattern can contain wild card characters - % (percentage) and (underscore).
The % is used to denote any number of unknown characters and _ denotes one unknown character.
To denote more than one unknown character using _, the number of _ must be equal to the number of unknown characters.
SELECT FIRST_NAME, LAST_NAME, STATE FROM CUSTOMER WHERE STATE LIKE 'K%';
SELECT FIRST_NAME, LAST_NAME, STATE FROM CUSTOMER WHERE FIRST_NAME LIKE '%RAJ%';
SELECT FIRST_NAME, LAST_NAME, ADD2, STATE FROM CUSTOMER WHERE ADD2 LIKE 'TEX_S';
Prof. Ashay Dharwadker