sql find partial string in all tables code example Example: search for partial string in sql Where FirstName LIKE '%R%'