search partial match of column in sql with another column code example Example: search for partial string in sql Where FirstName LIKE '%R%'