I used this when looking for a phone number. I already knew which column to look in. If you don't know which column might have it, then I guess you have to check all the columns

exec sp_msforeachtable 'Select ''[?]'' as Table_Name, * from ?

where phone in (''2035551212'',''9145551212'')'