how to find partial match in sql server code example

Example 1: search for partial string in sql

Where FirstName LIKE '%R%'

Example 2: partial search in sql

Partial Search Example
SELECT FIRST_NAME , LAST_NAME 
FROM EMPLOYEES 
WHERE FIRST_NAME LIKE '%d%' ;