searching a value in a variable/field in all tables in a schema

[Ruiqiang Chen]

Does anyone have experience of searching a value in a variable/field in all
tables in a schema?

If you can provide some code not creating stored procedure that would be
great.

Thanks,
Ray