Is there a way to search a schema and get the table and column name(s) that holds a particular value?

I'm need to find what column(s) in the schema that has the value "Charlotte" in it.

Any ideas or hints would be greatly appreciated.

Thanks,
smoothyc