I just used this yesterday, if you're ever in the market for a quick select:
sp_MSForEachDB @command1='USE ?;
SELECT
Table_Catalog
,Table_Schema
,Table_Name
,Column_Name
,Data_Type
,Character_Maximum_Length
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE = ''NVARCHAR'' and COLUMN_NAME like ''Recall%'' and TABLE_NAME LIKE ''%SAMPLE%'''