search for partial string in sql code example

Example: search for partial string in sql

Where FirstName LIKE '%R%'