sql query to match partial string code example Example: search for partial string in sql Where FirstName LIKE '%R%'