Search specific Table for a value

When you need to find a value but are not sure in which column it appears. Table is too large to search by each column.
Two separate stored procedures.