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