find names from a table starting with a particular letter code example

Example: find names from a table starting with a particular letter

SELECT * FROM department WHERE NAME LIKE 'H%';